Re: [solved]LOAD DATA INTO doesn't work correctly with utf8

2007-08-30 Thread Ananda Kumar
Okie, i will also try this, as we also load data from a flat file. regards anandkl On 8/31/07, Harald Vajkonny <[EMAIL PROTECTED]> wrote: > > Hi Ananda, > > Ananda Kumar schrieb: > > > > So you set the collation_database=utf8_bin, what was your > > character_set_database values. > character_set_

Re: [solved]LOAD DATA INTO doesn't work correctly with utf8

2007-08-30 Thread Harald Vajkonny
Hi Ananda, Ananda Kumar schrieb: > > So you set the collation_database=utf8_bin, what was your > character_set_database values. character_set_database is "utf8". The collation utf8_bin slows down queries, but is necessary in dealing with multilingual information. utf8_general_ci is faster, but can

Re: [solved]LOAD DATA INTO doesn't work correctly with utf8

2007-08-30 Thread Ananda Kumar
Hi Harald, So you set the collation_database=utf8_bin, what was your character_set_database values. regards anandkl On 8/30/07, Harald Vajkonny <[EMAIL PROTECTED]> wrote: > > Harald Vajkonny schrieb: > > In doing this I got another idea: Does anybody know the difference > > between the collatio

Re: [solved]LOAD DATA INTO doesn't work correctly with utf8

2007-08-30 Thread Harald Vajkonny
Harald Vajkonny schrieb: > In doing this I got another idea: Does anybody know the difference > between the collations utf8_general_ci, utf8_unicode_ci and utf8_bin? > I'll try these first and then get back to you about the results. > That was it. If I choose utf8_bin as collation everything wor