Re: load data infile and character set

2007-10-29 Thread mysql
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] default-charact

Re: load data infile and character set

2007-10-28 Thread Ananda Kumar
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. >

Re: load data infile and character set

2007-10-28 Thread Dušan Pavlica
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 mys

Re: load data infile and character set

2007-10-26 Thread Baron Schwartz
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

Re: load data infile and character set

2007-10-26 Thread Baron Schwartz
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 b

Re: load data infile and character set

2007-10-26 Thread mysql
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 b

load data infile and character set

2007-10-26 Thread Caleb Racey
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 INFIL