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

2007-08-31 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 not

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

2007-08-31 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_database is

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 works

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 collations