Re: [GENERAL] Re: [GENERAL] Re: [GENERAL] Re: [GENERAL] Different encoding for string values and identifier strings? Or (select 'tést' as tést) returns different values for string and identifier...

Поиск
Список
Период
Сортировка
От Francisco Figueiredo Jr.
Тема Re: [GENERAL] Re: [GENERAL] Re: [GENERAL] Re: [GENERAL] Different encoding for string values and identifier strings? Or (select 'tést' as tést) returns different values for string and identifier...
Дата
Msg-id AANLkTintX26YzpsS+b-Aqt4epZgQk7JrhCyCwLFkgakz@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Re: [GENERAL] Re: [GENERAL] Re: [GENERAL] Different encoding for string values and identifier strings? Or (select 'tést' as tést) returns different values for string and identifier...  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general


Hmmmmm,

I'm using osx 10.6.6 and I compiled PG myself from source. Is there any configure option or any library I may use to get the correct behavior? Is there any runtime setting I can make to change this tolower() behavior, maybe skip the call?

Thanks in advance.

--
Sent from my Android phone

Francisco Figueiredo Jr.
Npgsql lead developer
fxjr.blogspot.com
twitter.com/franciscojunior

Em 18/03/2011 22:01, "Tom Lane" <tgl@sss.pgh.pa.us> escreveu:
> "Francisco Figueiredo Jr." <francisco@npgsql.org> writes:
>> My database has encoding set to UTF-8 although my lc_collate is pt.BR.UTF-8
>> this lc setting my have cause some trouble?
>
> Hmmm ... actually, it strikes me that this may be a downcasing problem.
> PG will try to feed an unquoted identifier through tolower(), and that
> basically can't work on multibyte characters. Most implementations of
> tolower() are smart enough to not change high-bit-set bytes in UTF8
> locales, but maybe your platform's is not ...
>
> regards, tom lane

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

Предыдущее
От: Stefan Keller
Дата:
Сообщение: Insert value input syntax of an array of types without ARRAY/ROW nor casting?
Следующее
От: Alban Hertroys
Дата:
Сообщение: Re: Insert value input syntax of an array of types without ARRAY/ROW nor casting?