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

Okie, i will also try this, as we also load data from a flat file.

regards
anandkl

On 8/31/07, Harald Vajkonny <vajkonny@t-online.de> 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 "utf8". The collation utf8_bin slows down
> queries, but is necessary in dealing with multilingual information.
> utf8_general_ci is faster, but can not distinguish in keys between
> symbols which are sorted at the same position in national character
> sets, like e.g. German "a" and "ä", or French "e" and "é".
>
> Regards,
> Harald
>
> --
> "Wouldn't the sentence 'I want to put a hyphen between the words Fish
> and And and And and Chips in my Fish-And-Chips sign' have been clearer
> if quotation marks had been placed before Fish, and between Fish and
> and, and and and And, and And and and, and and and And, and And and
> and, and and and Chips, as well as after Chips?"
>
>
Received on Fri Aug 31 02:55:02 2007