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

From: "Francisco Figueiredo Jr(dot)" <francisco(at)npgsql(dot)org>
To: PgSql General <pgsql-general(at)postgresql(dot)org>
Subject: 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:13:18
Message-ID: AANLkTinSd+PKQFTDMSJ3cMpzBUkkhf-itWBcjm2UpJKQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message general_lee 2011-03-15 18:14:45 Re: How to add hosts to pg_hba.conf and postgresql.conf?
Previous Message Alphadion 2011-03-15 18:08:50 Re: PostgreSQL for Holdem Manager could not be installed.