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

Francisco Figueiredo Jr. <francisco@npgsql.org> wrote:

> Hi all!
>
> I received a bug report about problems with identifiers.
>
> If I do the following select:
>
> select 1 as tést
>
> The column name returned contains strange chars.
>
> If I do:
>
> select 'tést' as tést
>
> the select value returned is ok but the column name is not. :(
>
> Is there any configuration I need to change to specify the encoding of
> the identifiers?

test=# select 'tést' as "tést";
 tést
------
 tést

looks okay for me ...


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°