Hi,
Try this.
set session collation_database=latin1_swedish_ci;
set session character_set_database=latin1;
regards
anandkl
On 10/29/07, Dušan Pavlica [EMAIL PROTECTED] wrote:
Are you sure your file is coded in utf8? Character set of your file must
be same as charset of your database.
Are you sure your file is coded in utf8? Character set of your file must
be same as charset of your database.
Dusan
Caleb Racey napsal(a):
Does anyone know how to get the load data infile command to load utf8 data?
I have setup a database as utf8 with a collation of utf8_general_ci, the
Ananda Kumar wrote:
Hi,
Try this.
set session collation_database=latin1_swedish_ci;
set session character_set_database=latin1;
Rather:
set session collation_database=utf8_general_ci;
set session character_set_database=utf8;
Also, make sure you have these in my.cnf:
[client]
Does anyone know how to get the load data infile command to load utf8 data?
I have setup a database as utf8 with a collation of utf8_general_ci, the
mysqld server is started with --character-set-server=utf8. Server variables
say character_set_database = utf8. I use the sql below
LOAD DATA
Caleb Racey wrote:
Does anyone know how to get the load data infile command to load utf8 data?
I have setup a database as utf8 with a collation of utf8_general_ci, the
mysqld server is started with --character-set-server=utf8. Server variables
say character_set_database = utf8. I use the sql
Caleb Racey wrote:
Does anyone know how to get the load data infile command to load utf8 data?
I have setup a database as utf8 with a collation of utf8_general_ci, the
mysqld server is started with --character-set-server=utf8. Server variables
say character_set_database = utf8. I use the sql
Caleb Racey wrote:
On 10/26/07, Baron Schwartz [EMAIL PROTECTED] wrote:
Caleb Racey wrote:
It is indeed buggy and badly documented. It depends on the current
database's character set instead. Try this:
SET NAMES utf8;
SET character_set_database=utf8;
LOAD DATA INFILE...
Baron
Thanks for