This is the query our user sent as one of the problems: select "zurÃck" as zurÃck3_103_ from "Tabelle" tabellenhib0_ And here is the link to our bug report: http://pgfoundry.org/tracker/index.php?func=detail&aid=1010988&group_id=1000140&atid=590 I didn't test putting double quotes in the column name identifier as the bug report isn't using it. What happens if you remove the double quotes in the column name identifier? Thanks in advance. On Tue, Mar 15, 2011 at 15:21, Andreas Kretschmer <akretschmer@xxxxxxxxxxxxx> wrote: > Francisco Figueiredo Jr. <francisco@xxxxxxxxxx> 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Â > > -- > Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) > 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
