Re: FN-FORUM: MySQL CAse Sensitive

date posted 3rd August 2005 19:20

force both into all uppercase or lowercase.

> Hi All
>
> Have a MySQL query issue - I have a site that requires users to enter
> their surname to validate a login, The data stored in the database could
> be in any case, i.e. SMITH, smith or Smith - Is there a way of getting
> the query so search the surname field ignoring case? I've Googled but
> not sure I'm search the right term.
>
> Thanks
> Paul
>
>
>
>
> Paul Summers
> Systems Developer
>
>
> Digital Arts IT Consultancy
>
>
> Telephone. 0870 01 02 226
> Fax. 0870 01 02 227
> Email. [EMAIL REMOVED]
>
>
> http://www.daitc.com
>
>
> Please Note:
> This message contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender.
>
>
> This message has been scanned by Symantec Enterprise AV Version 9.0 prior to dispatch.
>
>
> The views of the author may not necessarily reflect those of the Company. Any opinions or other information in this message that do not relate to the official business of the Company are neither given nor endorsed by it.
--
Graham Stark, Virtual Worlds
phone: (+044) 01908 618239 mobile: 07952 633185
skype: graham_k_stark
Homepage http://www.virtual-worlds.biz/people/graham_s
Virtual Chancellor http://www.virtual-worlds.biz/vwc