Re: Chinese in Postgres - Mailing list pgsql-hackers

From Nicolas Barbier
Subject Re: Chinese in Postgres
Date
Msg-id CAP-rdTZ4cxgPzHLKakBvvTBxaWMOBFRuY4xDf6r-Ef5oL2a1uQ@mail.gmail.com
Whole thread Raw
In response to R: Re: Chinese in Postgres  ("ciifrancesco@tiscali.it" <ciifrancesco@tiscali.it>)
List pgsql-hackers
[ Could you please trim your citations, i.e., please don’t top-post:
https://en.wikipedia.org/wiki/Posting_style#Top-posting ]

2013/8/16 Francesco <ciifrancesco@tiscali.it>:

> Thanks for your answer.
> Yes, the client is also UTF8:
>
> MyDB=# show
> client_encoding;
> client_encoding
> -----------------
> UTF8
> (1 row)

I guess that this is the client encoding used by psql. I suspect your
C++-program doesn’t use client encoding UTF8. What library are you
using, libpq? Did you run the psql instance (whose output you pasted)
on Windows or on some kind of UNIX-machine over SSH? Does your
problematic C++-program run on Windows or the UNIX-machine?

(The “client encoding” is not a property of the database, but of the
specific client you are using. The C++-program’s client encoding might
therefore by entirely different from the one used by psql, especially
if you don’t run them on the same machine.)

[ BTW, I think this question really doesn’t belong on -hackers, as
no-one seems to think it is a bug, nor is it a question about
PostgreSQL internals. ]

Nicolas

--
A. Because it breaks the logical sequence of discussion.
Q. Why is top posting bad?


pgsql-hackers by date:

Previous
From: Fabien COELHO
Date:
Subject: Re: [PATCH] pg_sleep(interval)
Next
From: Hannu Krosing
Date:
Subject: Re: Feature Request on Extensions