Caleb Racey wrote:
On 10/26/07, Baron Schwartz <[EMAIL PROTECTED]> 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
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]