Problem about mysqlimport or LOAD DATA
Posted by: Hu Hailin
Date: January 26, 2006 11:58PM

I'm using MySQL 4.1.13.
I tried to import a csv file into my database in an easy way, so I used mysqlimport.

The data file is encoded by sjis and the table is also created in sjis. But it seems that neither mysqlimport nor LOAD DATA does not support character set. The data imported can not read.

I tried something like

$mysqlimport --default-character-set=sjis ...
or
$mysql --default-character-set=sjis -e 'LOAD DATA ...'

but failed.
Any help?



Edited 1 time(s). Last edit at 01/27/2006 12:58AM by Hu Hailin.

Options: ReplyQuote


Subject
Views
Written By
Posted
Problem about mysqlimport or LOAD DATA
2940
January 26, 2006 11:58PM


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.