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...

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