Do you have a question? Post it now! No Registration Necessary. Now with pictures!
February 28, 2006, 7:49 pm
rate this thread
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
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
- » Need to combine 2 tables into 1 uniquely-rowed table - help
- — Next thread in » MySQL Database Forum
- » Americanas.com SALDO de TVs Com at 80% de Desconto (29798)
- — Newest thread in » MySQL Database Forum