MySQL truncates diacritic and accented characters...

Viktoras Didziulis viktoras at ekoinf.net
Tue Jan 2 06:45:25 EST 2007


Sorry for a monologue, posting just in case somebody encounters similar
problem with truncated charsets in MySQL. 
The other solution is describe field with: 
myfieldname VARCHAR(45) CHARACTER SET binary 
and an alternative from: 
myfieldname VARBINARY(45) 
 
However the following won't work - 2 byte characters will still be truncated
(even if I change the session's charset to utf8): 
myfieldname VARCHAR(45) BINARY 
myfieldname VARCHAR(45) CHARACTER SET utf8 COLLATE utf8_bin 
 
BR 
V.



More information about the use-livecode mailing list