Also friends, When i see this data in the vi editor it looks like this " Other Home DÃ(c)cor " Just wanted to give information. Please help me.
regards anandkl On 5/19/07, Ananda Kumar <[EMAIL PROTECTED]> wrote:
Hi All, I am loading data into mysql database using LOAD DATA INFILE. After the load i am getting this error. Warning | 1366 | Incorrect string value: '\xE9cor' for column 'CATEGORY_NAME' at row 2137 . My database character set is as below character_set_database | utf8 character_set_client | latin1 | | character_set_connection | latin1 character_set_server | utf8 | | character_set_system | utf8 and collation information is collation_connection | latin1_swedish_ci | | collation_database | utf8_general_ci | | collation_server | utf8_general_ci I have spooled this data from oracle and trying to insert this data into mysql. Can you please set me know how should i fix this error. The actual value in oracle database is "Other Home Décor", but in the spool file its coming as some "Other Home D\351cor". Can you please let me know how i can fix this error. regards anandkl
