[prev in list] [next in list] [prev in thread] [next in thread] 

List:       mysql
Subject:    Re: load data infile and character set
From:       mysql () subtropolix ! org
Date:       2007-10-29 15:01:09
Message-ID: 4725F5B5.7040100 () subtropolix ! org
[Download RAW message or body]

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-character-set=utf8

[mysqld]
default-character-set=utf8
init-connect='SET NAMES utf8'

And you might want to add these also:

collation_server=utf8_unicode_ci
character_set_server=utf8

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=mysql-marcsub@progressive-comp.com

[prev in list] [next in list] [prev in thread] [next in thread]