Re: need help...LOAD DATA INFILE

2007-05-21 Thread Ananda Kumar
Hi All, I was able to load data properly. We need to set the parameter set session collation_database=latin1_swedish_ci; set session character_set_database=latin1; please check this url for more info http://lists.mysql.com/commits/16915 On 5/19/07, Ananda Kumar <[EMAIL PROTECTED]> wrote: Hi

Re: need help...LOAD DATA INFILE

2007-05-19 Thread Ananda Kumar
Also friends, When i see this data in the vi editor it looks like this " Other Home DÃ(c)cor " Just wanted to give information. Please help me. regards anandkl On 5/19/07, Ananda Kumar <[EMAIL PROTECTED]> wrote: Hi All, I am loading data into mysql database using LOAD DATA INFILE. After the l

need help...LOAD DATA INFILE

2007-05-19 Thread Ananda Kumar
Hi All, I am loading data into mysql database using LOAD DATA INFILE. After the load i am getting this error. Warning | 1366 | Incorrect string value: '\xE9cor' for column 'CATEGORY_NAME' at row 2137 . My database character set is as below character_set_database | utf8 character_set_client