MySQL with utf-8 charset - problem with "LOAD DATA"
am 28.02.2006 20:49:57 von JoachimEnvironment: Windows XP - german settings.
MySQL: 5.0.18-nt
Database charsets have been changed from 'latin1' (where 'LOAD DATA'
worked fine) to utf-8 to resolve some charset issues with Perl/Tk.
When loading a csv-file to the data base in the new utf-8 environment
and an 'Umlaut' appears within a field the rest of the field including
the 'Umlaut' gets truncated.
Because the csv-file was created under Windows I used the 'SET
NAMES'-directive:
SET NAMES 'latin1';
LOAD DATA INFILE '.....' INTO TABLE ....
The "SHOW VARIABLES LIKE 'character_set\_%'"-statement displayed all
charset-variables are set to 'utf-8'.
Can anyone help or advise? Thanx for your help.
Best regards, Jo Wesenberg