Re: [pgsql-advocacy] interesting PHP/MySQL thread

Поиск
Список
Период
Сортировка
От Arjen van der Meijden
Тема Re: [pgsql-advocacy] interesting PHP/MySQL thread
Дата
Msg-id 000b01c33969$982ed060$3ac15e91@acm
обсуждение исходный текст
Ответ на Re: [pgsql-advocacy] interesting PHP/MySQL thread  (nolan@celery.tssi.com)
Список pgsql-general
> nolan@celery.tssi.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




В списке pgsql-general по дате отправления: