From: | "Francisco Figueiredo Jr(dot)" <francisco(at)npgsql(dot)org> |
---|---|
To: | Andreas Kretschmer <akretschmer(at)spamfence(dot)net> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | 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... |
Date: | 2011-03-15 18:52:56 |
Message-ID: | AANLkTinN2Ei2DKv6gy1tCdz9=UQ1hSkw5MX9wG+9rh=d@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)spamfence(dot)net> wrote:
> Francisco Figueiredo Jr. <francisco(at)npgsql(dot)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(at)postgresql(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | general_lee | 2011-03-15 20:33:48 | Re: How to add hosts to pg_hba.conf and postgresql.conf? |
Previous Message | Andreas Kretschmer | 2011-03-15 18:45:27 | Re: Re: [GENERAL] Different encoding for string values and identifier strings? Or (select 'tést' as tést) returns different values for string and identifier... |