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" <[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 I have it so that it is indeed case sensitive because I'm importing
> lots of data from Oracle which is case sensitive.
>
VARCHAR column is compared in case-insensitive fashion. You can define column as BINARY if you use 3.23 or 4.0 MySQL server. If you use 4.1 MySQL server you can define case sensitive collation.
-- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
_________________________________________________________________
Help protect your PC: Get a free online virus scan at McAfee.com. http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
