Page 1 of 1

Fix for german-Characters

Posted: Fri Feb 13, 2009 2:17 am
by CChris
Hello!

For those who set the "Local" Settings for the Shop to "Germany" I've added a fix for the Database-Entries for "zone"
(Select of State/Region) because the first and last Entry:

Code: Select all

UPDATE `zone` SET `name` = 'Baden-Württemberg' WHERE `country_id` = '81' AND `code` =  'BAW';
UPDATE `zone` SET `name` = 'Thüringen' WHERE `country_id` = '81' AND `code` =  'THE';
This are the Entries from the install-sql-file:

Code: Select all

INSERT INTO `zone` (`zone_id`, `country_id`, `code`, `name`) VALUES ('1254', '81', 'BAW', 'Baden-Württemberg');
INSERT INTO `zone` (`zone_id`, `country_id`, `code`, `name`) VALUES ('1269', '81', 'THE', 'Thüringen');

Re: Fix for german-Characters

Posted: Mon Feb 16, 2009 7:48 pm
by JNeuhoff
The Umlaut characters should really be stored as UTF-8, that is, as 2-bytes sequences, in the database. Make sure that the MySQL uses the UTF-8 collation.

Re: Fix for german-Characters

Posted: Mon Feb 16, 2009 7:52 pm
by CChris
My DB uses UTF-8
the problem is, that if I add an adress with umlaut chars, there are stored like this one, i've posted above.

All other changes doesn't work at all... :-/

But i will try to find a way... ;)