MySQL Forums
Forum List  »  Newbie

Server in UTF8 + WinXP and "LOAD DATA INFILE"
Posted by: Az Erty
Date: April 24, 2012 11:57AM

Dear all,

I readed quite some posts already but still have trouble to figure where's the problem and how to solve it.

MySQL server 5.5.23 x64 running on a Windows2008 with my.ini:
--
[client]
port=3306

[mysql]
default-character-set=utf8

[mysqld]
port=3306
character-set-server=utf8
default-storage-engine=INNODB
sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
--
If I check my shema, table, column properties, all are configured as utf8.

MySQL Workbench 5.2.39 x86 running on WindowsXP.
Now if I try to run the following query:
load data local infile "C:/Temp/data.txt"
replace into table Test
fields terminated by '\t' lines terminated by '\r\n'

I always get this error (tried a few worksaround from several posts):
Error Code: 1366. Incorrect string value: '\xE9...' for column 'ADDRESS' at row 6

where \xE9 is the character 'é' translated somewhere, somehow...

So how could I :
- troubleshoot the problem further
- eventually fix the problem if someone have a ready made solution (not involving changing anything in server collation)

Thanks in advance for your input !

Az

Options: ReplyQuote


Subject
Written By
Posted
Server in UTF8 + WinXP and "LOAD DATA INFILE"
April 24, 2012 11:57AM


Sorry, you can't reply to this topic. It has been closed.

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.