Good morning.
I have a table with field name DATA type tinytext. The table is already
populated. I need DATA to be unique. It seems that MySQL doesn't look at
the uniqueness of a field in a binary fashion.
Example (chosen because I think it is just plain odd)
june = Júne
If I query as -
Select
BINARY is for CHAR and VARCHAR, but he's using TINYTEXT. The binary version
of TINYTEXT is TINYBLOB.
Michael
mos wrote:
Paul,
Just use the "Binary" column attribute to make it case sensitive..
From MySQL Manual: http://dev.mysql.com/doc/mysql/en/CHAR.html
As of MySQL 4.1, values in CHAR
