On Wednesday June 22 2011 01:25:36 Benny Pedersen wrote: > since so many have problems i share my mysql shemas :=) > `token` binary(5) NOT NULL,
Yes, the binary or varbinary is the key to a solution here. Mucking with utf-8 vs latin-1 is just covering but not solving the most glaring problem here, namely that a token must not be associated with any character set, as it does not obey any such rules, nor should it be treated case-insensitively (as char is, which is possibly a reason for more than two record changes as reported by Dave). Will take a closer look... Mark
