Postgres Pro
Downloads
Home   >   mailing lists

Different encoding for string values and identifier strings? Or (select 'tést' as tést) returns different values for string and identifier... - Mailing list pgsql-general

From Francisco Figueiredo Jr.
Subject Different encoding for string values and identifier strings? Or (select 'tést' as tést) returns different values for string and identifier...
Date
Msg-id AANLkTinSd+PKQFTDMSJ3cMpzBUkkhf-itWBcjm2UpJKQ@mail.gmail.com
Whole thread Raw
Responses Re: 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>)
List pgsql-general
Tree view 
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?

I'm using UTF-8 for my database.

Thanks in advance.


--
Regards,

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

pgsql-general by date:

Previous
From: Alphadion
Date:
Subject: Re: PostgreSQL for Holdem Manager could not be installed.
Next
From: general_lee
Date:
Subject: Re: How to add hosts to pg_hba.conf and postgresql.conf?