Re: Different thoughts

Alan Cox (alan nospam at redhat.com)
Wed, 10 Mar 1999 08:41:58 -0500 (EST)

>
> BINARY means, that the VARCHAR field will be regarded case sensitive
> regarding comparisons (i.e. sorting and indexes). So you have to use
> VARCHAR BINARY to be able to handle unicode (also UTF8) properly.

"Also UTF8"..

UTF8, UTF16 and UTF32 are the encodings of Unicode. UTF8 is the variable
length encoding where an ascii nul always means end of string and ascii
comes out as ascii still (handy for dumber clients)

Alan