Re: Locale-based identifier conversion and Turkish

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Locale-based identifier conversion and Turkish
Дата
Msg-id 14537.1071519263@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Locale-based identifier conversion and Turkish  (Devrim GUNDUZ <devrim@gunduz.org>)
Ответы conversion_create.sql  (Michael Brusser <michael@synchronicity.com>)
Re: Locale-based identifier conversion and Turkish  (Devrim GUNDUZ <devrim@gunduz.org>)
Список pgsql-hackers
Devrim GUNDUZ <devrim@gunduz.org> writes:
> Now, PostgreSQL 7.4 initdb fails if run with locale set to tr_TR:

Ugh :-(

> As you can see "I" in "VOID" gets converted to i-dotless in conformance
> to tr_TR Locale conversion rules, which is not an expected behaviour for
> Turkish users who set their locale to tr_TR.

Why is it not expected behavior?  The SQL99 spec has not changed from
what it said when we discussed this last year: case conversion of
identifiers is *not* to be done in plain-ASCII rules.  Admittedly it
says "unicode" and not "locale", but you'd have the same problem if we
had a full unicode implementation, no?

My feeling is that the best answer is to use lower case names to
reference identifiers in the initdb code.  This is not a real pleasant
prospect, but I can't see giving up on spec-compatible case folding ...
        regards, tom lane


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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: [PATCHES] fork/exec patch
Следующее
От: Michael Brusser
Дата:
Сообщение: conversion_create.sql