Re: #1366 - Incorrect string value: '\xBE inch...' for column '
Posted by: George Mikhaylov
Date: October 15, 2009 08:24PM

Thank you, Rick,
I did SET NAMES utf8, but during load process:
LOAD DATA INFILE 'C:\\sqlProd\\psa\\psa_in.txt' REPLACE INTO TABLE `psa_in`
FIELDS TERMINATED BY ' '
LINES TERMINATED BY '\r\n'
I have #1366 - Incorrect string value: '\xBD\x94 x 2...' for column 'Long_Description' at row 1
I have in input file characters like this 35 ½” x 23 ½
Do you know which SET NAMES .. I should issue before load ?

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: #1366 - Incorrect string value: '\xBE inch...' for column '
6900
October 15, 2009 08:24PM


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.