Character sets
Posted by: Mike H
Date: April 26, 2010 02:03PM

I'm trying to load a unicode text file using LOAD DATA INFILE. I've set the CHARACTER SET flag to 'utf8'. I receive an error when the file has a byte order mark (BOM):

Quote

Error Code: 1366
Incorrect integer value: '1' for column 'position_id' at row 1

Removing the BOM works, but then it fails when it encounters unicode character 2191 (↑), resulting in this error:

Quote

Error Code: 1366
Incorrect string value: '\xE2\x86\x91' for column 'symbol_low' at row 302

Is this a bug? The character renders fine in my text editors and web browsers.



Edited 1 time(s). Last edit at 04/26/2010 02:04PM by Mike H.

Options: ReplyQuote


Subject
Views
Written By
Posted
Character sets
3547
April 26, 2010 02:03PM


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.