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] Different encoding for string values and identifier strings? Or (select 'tést' as tést) returns different values for string and identifier...
Дата
Msg-id AANLkTinN2Ei2DKv6gy1tCdz9=UQ1hSkw5MX9wG+9rh=d@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Re: [GENERAL] Different encoding for string values and identifier strings? Or (select 'tést' as tést) returns different values for string andidentifier...  (Andreas Kretschmer <akretschmer@spamfence.net>)
Ответы 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." <francisco@npgsql.org>)
Список pgsql-general
Hmmmmmmmm,

What would change the encoding of the identifiers?

Because on my dev machine which unfortunately isn't with me right now
I can't get the identifier returned correctly :(

I remember that it returns:

 test=*# select 'tést' as tést;
  tst
 ------
  tést

Is there any config I can change at runtime in order to have it
returned correctly?

Thanks in advance.


On Tue, Mar 15, 2011 at 15:45, Andreas Kretschmer
<akretschmer@spamfence.net> wrote:
> Francisco Figueiredo Jr. <francisco@npgsql.org> wrote:
>
>>
>> What happens if you remove the double quotes in the column name identifier?
>
> the same:
>
> test=*# select 'tést' as tést;
>  tést
> ------
>  tést
> (1 Zeile)
>
>
>
> Andreas
> --
> Really, I'm not out to destroy Microsoft. That will just be a completely
> unintentional side effect.                              (Linus Torvalds)
> "If I was god, I would recompile penguin with --enable-fly."   (unknown)
> Kaufbach, Saxony, Germany, Europe.              N 51.05082°, E 13.56889°
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>



--
Regards,

Francisco Figueiredo Jr.
Npgsql Lead Developer
http://www.npgsql.org
http://fxjr.blogspot.com
http://twitter.com/franciscojunior

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

Предыдущее
От: George Woodring
Дата:
Сообщение: autovacuum issue after upgrade to 9.0.1
Следующее
От: general_lee
Дата:
Сообщение: Re: How to add hosts to pg_hba.conf and postgresql.conf?