Gossamer Forum
Quote Reply
Case?
Is MySQL case sensative in its queries? I have;

SELECT * FROM `Advertisers` WHERE `Advertiser` = 'Andy'

But, for some reason it keeps picking up the user 'andy' (I have 3 users in the database, Andy, andy and someone)...I've never encountered this before....is it a MySQL thing, or something I need to do with my code?

Thanks

Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Quote Reply
Re: [Andy.] Case? In reply to
MySQL colums by default are case-insensitive. If you want your column to be case-sensitive then you'll have to set it's type to BINARY or BLOB. For a workaround, however, try this:

http://www.mysql.com/...ivity_Operators.html

- wil
Quote Reply
Re: [Andy.] Case? In reply to
...and if SELECT BINARY fails, you better upgrade mysql pronto!! Smile
Quote Reply
Re: [Wil] Case? In reply to
Wow...you learn something new every day. Thanks for that Wil...I changed the field to a BLOB, rather than TEXT. Its all working like a charm now Wink

Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Quote Reply
Re: [Andy.] Case? In reply to
It's amazing what a quick search at http://www.mysql.com yields. :-)

- wil