Post by CChris » Fri Feb 13, 2009 2:17 am

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');

New member

Posts

Joined
Tue Feb 10, 2009 8:36 am

Post by JNeuhoff » Mon Feb 16, 2009 7:48 pm

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.

Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig


User avatar
Guru Member

Posts

Joined
Wed Dec 05, 2007 3:38 am


Post by CChris » Mon Feb 16, 2009 7:52 pm

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... ;)

New member

Posts

Joined
Tue Feb 10, 2009 8:36 am
Who is online

Users browsing this forum: Bing [Bot] and 90 guests