Caleb Racey wrote:
> On 10/26/07, Baron Schwartz <baron@stripped> wrote:
>> Caleb Racey wrote:
>>>> It is indeed buggy and badly documented. It depends on the current
>>>> database's character set instead. Try this:
>>>>
>>>> SET NAMES utf8;
>>>> SET character_set_database=utf8;
>>>> LOAD DATA INFILE...
>>>>
>>>> Baron
>>>>
>>> Thanks for the suggestion
>>>
>>> I'm afraid i get the same behaviour when i try this approach accented
>> values
>>> still truncate at the accent when i use load data infile.
>>>
>> OK, the next suggestion is to use the 'binary' character set. By the
>> way, I accidentally omitted quotes above; I should have typed
>>
>> SET character_set_database='utf8';
>>
>> You should verify your connection's character sets with
>>
>> SHOW VARIABLES LIKE '%character%';
>>
>> Try it with 'binary' and see if that works.
>>
>> Baron
>
> thanks again
> I'm afraid 'binary' achieved the same result as did using utf8 with
> quotes.
I'm out of ideas, then. I wish I could help more.
Baron
