 |
 |
Find a programming school near you
php3-list | 199908
Date: 08/06/99
- Next message: Vladimir N. Goida: "[PHP3] Fw: [PHP3] Setup Trouble.."
- Previous message: blueless <email protected>: "RE: [PHP3] Setup Trouble.."
- In reply to: bben: "[PHP3] mysql is case sensitive?"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Use the BINARY keyword on each column you want to be case sensitive.
ie. COLUMN_X CHAR(128) BINARY NOT NULL
Then it will use case sensitive searches and selects. It is important to note
that even if a column doesn't include the BINARY keyword, all data is still
stored in the correct case.
At 03:21 PM 8/6/99 +0800, bben wrote:
>hello,
>
>I use mysql3.22.25 on linux,
>I found mysql is not case sensitive,
>for example,I use : "select 'abc'='ABC'"
>It return 1.
>
>How can I set mysql to case sensitive?
>Thanks.
> .___.
> / \
> | O _ O |
> / \_/ \
> .' / \ `.
> /~ | | ~\
>(_ | | _)
> ~ \ / ~
> __\_>-<_/__
> ~;/ \;~
Regards,
Adam Whitehead
CEO - Netherworld Media
E-mail: adam <email protected>
Phone: +61 (889) 279 898
FAX: +61 (889) 273 889
Mobile: +61 (411) 241 120
Musicseek (http://www.musicseek.net)
-- PHP 3 Mailing List <http://www.php.net/> To unsubscribe, send an empty message to php3-unsubscribe <email protected> To subscribe to the digest, e-mail: php3-digest-subscribe <email protected> To search the mailing list archive, go to: http://www.php.net/mailsearch.php3 To contact the list administrators, e-mail: php-list-admin <email protected>
- Next message: Vladimir N. Goida: "[PHP3] Fw: [PHP3] Setup Trouble.."
- Previous message: blueless <email protected>: "RE: [PHP3] Setup Trouble.."
- In reply to: bben: "[PHP3] mysql is case sensitive?"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
