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