Postgres Pro
Downloads
Home   >   mailing lists

Re: Characters - Mailing list pgsql-general

From JotaComm
Subject Re: Characters
Date
Msg-id CAA8OQ6--tZCmRxetee0GCsHTe2fHS86g-1+rFL6hCC-9wWYAkw@mail.gmail.com
Whole thread Raw
In response to Characters  ("P. Broennimann" <peter.broennimann@gmail.com>)
List pgsql-general
Tree view
Hello,


2013/4/10 P. Broennimann <peter.broennimann@gmail.com>
Hi there

I am using PG 9.2 and 'pg_database' shows 'en_US.UTF-8'.

I have a text 'Piqué' but this is shown in my application as 'Piqu?' so I was wondering where the problem is?

What is the result for these commands?

SHOW client_encoding;

and

SHOW server_encoding;

I am using Devart's 'PostgreSQL Data Access Components' to access PG from FreePascal.

In my FreePascal code I do use AnsiStrings and I cast the database results/text 'UTF8ToAnsi(...)'

Thanks for a hint!

Cheers,
P.



Regards

--
JotaComm
http://jotacomm.wordpress.com

pgsql-general by date:

Previous
From: JotaComm
Date:
Subject: Re: how to find which tables required indexes in postgresql
Next
From: Chris Curvey
Date:
Subject: Re: how to find which tables required indexes in postgresql