| From: | "Arjen van der Meijden" <acm(at)tweakers(dot)net> |
|---|---|
| To: | <nolan(at)celery(dot)tssi(dot)com> |
| Cc: | "'\"Advocacy PostgreSQL\"'" <pgsql-advocacy(at)postgresql(dot)org>, "'PostgreSQL-general'" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: [GENERAL] interesting PHP/MySQL thread |
| Date: | 2003-06-23 09:25:47 |
| Message-ID: | 000b01c33969$982ed060$3ac15e91@acm |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-advocacy pgsql-docs pgsql-general |
> nolan(at)celery(dot)tssi(dot)com wrote:
> MySQL also does case independent text comparisions, and
> apparently ONLY case-insensitive comparisons.
It's not very clearly described in the manual. But if you either specify
your textual fields 'binary' or use some form of 'like ... binary' query
it'll compare them case-sensitive, (apart from the strcmp-functions).
And in the case of a binary textual field the indices are also
case-sensitive :)
Regards,
Arjen
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Eric Frazier | 2003-06-23 11:09:20 | Re: [GENERAL] interesting PHP/MySQL thread |
| Previous Message | Arjen van der Meijden | 2003-06-23 09:21:25 | Re: [GENERAL] interesting PHP/MySQL thread |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | The Hermit Hacker | 2003-06-23 11:33:05 | Re: [GENERAL] interesting PHP/MySQL thread |
| Previous Message | Arjen van der Meijden | 2003-06-23 09:21:25 | Re: [GENERAL] interesting PHP/MySQL thread |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Harry Yau | 2003-06-23 10:31:41 | PL/PGSQL -- How To Return a Temp Table |
| Previous Message | Arjen van der Meijden | 2003-06-23 09:21:25 | Re: [GENERAL] interesting PHP/MySQL thread |