MySQL truncates diacritic and accented characters...

Viktoras Didziulis viktoras at ekoinf.net
Tue Jan 2 05:45:08 EST 2007


Just solved this issue by using BLOB datatype instead of VARCHAR. However I
am still wondering if there are other possible solutions... 
 
All the best! 
Viktoras 
 
-------Original Message------- 
 
From: Viktoras Didziulis 
Date: 01/02/07 11:27:52 
To: How to use Revolution 
Subject: MySQL truncates diacritic and accented characters... 
 
Happy new year for all and everybody! 
 
I know there are MySQL experts on this list :-). The problem I encountered 
recently with the MySQL 5 is that while loading table from file it truncates

all strings in varchar fields that have an accented or diacritic characters 
(these are names of taxonomists). Thus for example (Lacépède, 1803) is 
truncated to (Lac. Varchar maximum length is set to 255 and the length of 
the most truncated strings is below 20. Is there an easy way to overcome 
this misbehavior of the MySQL when populating tables from a file ? 
 
Tried using CHARSET utf8 when creating table or field, but it did not help 
either... Maybe collation would help, but which one - the default causes the

truncation ? 
 
Best wishes 
Viktoras 
_______________________________________________ 
use-revolution mailing list 
use-revolution at lists.runrev.com 
Please visit this url to subscribe, unsubscribe and manage your subscription
preferences: 
http://lists.runrev.com/mailman/listinfo/use-revolution



More information about the use-livecode mailing list