Re: UTF8 data import problem
Posted by:
Peter Naus
Date: September 03, 2007 02:11AM
G'day Donal,
Thanks for taking the time to respond to such a vague question...
I was exporting in ANSI CP1252, that's why the damn accented characters were escaped. I should have known. <sigh>
I can now get the LOAD DATA command to correctly read all the string data from the exported table, using the commandline utility (mysql.exe) and specifying the UTF8 CHARSET, so thank you for sorting that issue out for me!
I'm not sure why the LOAD DATA doesn't import the (now correctly exported data) when the database schema and the table I'm importing into already have the default charset set to UTF8, and the individual column datatypes are set as well. Maybe I'm misinterpreting how the LOAD DATA works? That's very possible (I live to be proven wrong)
In any case, thank you for sorting this problem out.
Subject
Views
Written By
Posted
12444
August 16, 2007 07:11AM
5142
August 16, 2007 11:03AM
7973
August 26, 2007 08:58PM
4979
August 27, 2007 12:41AM
5799
August 27, 2007 12:26PM
Re: UTF8 data import problem
4626
September 03, 2007 02:11AM
Sorry, you can't reply to this topic. It has been closed.
This forum is currently read only. You can not log in or make any changes. This is a temporary situation.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.