"gord barq" <[EMAIL PROTECTED]> wrote:
>
> I'm using MySQL 4.1 so how do I define case sensitive collation? Is it on
> the columns or on the indexes?
On column. Look at the collations of your character set using SHOW COLLATION command:
http://www.mysql.com/doc/en/Charset-SHOW-COLLATION.h
I'm using MySQL 4.1 so how do I define case sensitive collation? Is it on
the columns or on the indexes?
Thanks.
From: Victoria Reznichenko <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Subject: Re: Case sensitive indexes
Date: Tue, 26 Aug 2003 13:18:19 +0300
"gord barq" <
"gord barq" <[EMAIL PROTECTED]> wrote:
> I have the following index:
>
> CREATE UNIQUE INDEX SongTopic_idx ON SongTopic(songTitle, artist, album);
>
> Where songtitle, artist and album are varchar() columns.
>
> It appears that this index is not case sensitive. Is that correct? If so,
> how can
Hi Gord,
I understood that searches in general arecase insensitive (but I might be
wrong of course).
Try to use the word "BINARY" when creating the table or when making a SELECT.
I am not sure how you would have to apply this to the index.
Best regards
Nils Valentin
Tokyo/Japan
2003年 8月
I have the following index:
CREATE UNIQUE INDEX SongTopic_idx ON SongTopic(songTitle, artist, album);
Where songtitle, artist and album are varchar() columns.
It appears that this index is not case sensitive. Is that correct? If so,
how can I have it so that it is indeed case sensitive because
