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
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
mys
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
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
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
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