Hi Jerry,
Sorry, I should have mentioned that I use Windows XP with MySQL 5.0.15nt.
The script giving errors now is used once a year, and last year without any
warning.
Since last year all I changed was adding in my.ini:
# in [client] part
default-character-set=utf8
# in [mysqld] part
default-character-set=utf8
character-set-server = utf8
collation-server = utf8_general_ci
When I undo these changes, and stop and start mysql, the errors remain.
The Data.txt file (from an external source) looks okay with Wordpad.
TIA, Cor
----- Original Message -----
From: "Jerry Schwartz" <[EMAIL PROTECTED]>
To: "'C.R.Vegelin'" <[EMAIL PROTECTED]>; <mysql@lists.mysql.com>
Sent: Friday, April 18, 2008 2:30 PM
Subject: RE: data truncation warnings by special characters
>-----Original Message-----
From: C.R.Vegelin [mailto:[EMAIL PROTECTED]
Sent: Friday, April 18, 2008 8:42 AM
To: mysql@lists.mysql.com
Subject: data truncation warnings by special characters
Hi List,
I get strange "Data truncated for column Description" warnings
when loading a tab separated file with special characters.
[JS] This sounds like it is related to the problems I've been having. I
think I've come to an understanding of my issues, but I am not using LOAD
DATA INFILE. I'll be posting what I have learnt, once I get a chance, but
I
don't know if it will help you.
What is the source of your input data? Windows? Linux?
The definition of the target table is:
CREATE TEMPORARY TABLE tmp
( Code CHAR(8) NOT NULL,
Description TEXT NOT NULL,
KEY Code (Code)
) ENGINE = MyISAM CHARSET=UTF8;
The Load Into statement I use is:
LOAD DATA INFILE 'D:/Input/Data.txt' INTO TABLE tmp
FIELDS TERMINATED BY '\t' LINES TERMINATED BY '\r\n' IGNORE 0 LINES;
The truncation warnings are caused by words like PURÉES.
This leads to a truncted Description field like: "Jams, Jellies, Pur".
Any idea how to solve this ?
Thanks in advance, Cor
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]