Re: Character set/Collation problem in MySQL 4.1
Found this:
Just short note for everybody who has problem with LOAD DATA INFILE and
correct charset of the file. Loaded file must have SAME charset as *DATABASE*
which contains target table of LOAD DATA command. *Target table charset*
DOESN'T matter.
I didn't find any note about it in manual but I think it is
useful to know it.
Also once you got it imported in the *DATABASE* you move the data arround it seems without too much problems:
insert into db_utf.table_utf select * from db_chrst1.tbl_chrst1;
Subject
Views
Written By
Posted
7121
January 17, 2005 01:23PM
2801
January 20, 2005 02:12AM
2870
March 02, 2005 07:42AM
2941
April 02, 2005 01:18PM
2755
April 06, 2005 07:38AM
2167
November 01, 2006 04:20AM
2428
May 21, 2005 11:34AM
Re: Character set/Collation problem in MySQL 4.1
2425
August 03, 2005 04:46PM
2149
November 07, 2006 12:34AM
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.