Re: language code incompatibility in Windows

On Wed, Sep 07, 2016 at 11:02:28AM +0800, 阎兆珣 wrote:
>    For PG 9.1 ~ 9.5 in Windows 7 32bit
>
>    psql can not recognize Chinese database name while pgAdmin III can.
>
>    psql_Chinese

This is probably a symptom of a character encoding mismatch.  You ran psql in
a console window, so psql received your input encoded with the console input
code page.  Based on [1], pgAdmin III probably used UTF8 encoding in your
environment.  The default console input code page depends on locale settings,
but it is never UTF8.

This C program demonstrates psql's ability to connect to a Chinese-named
database on Windows (tested with binaries from [2]):

/* initdb --locale=C --encoding=UTF8 */
#include <stdlib.h>
int main(int argc, char **argv)
{
    system("createdb \xe5\xa3\xa4");
    system("psql -c "
       "\"select current_database(), octet_length(current_database())\" "
       "\xe5\xa3\xa4");
    return 0;
}

I recommend against non-ASCII characters in database names.  PostgreSQL
performs encoding conversion, according to the client_encoding setting, on
most of the database session.  It does not convert database names; it largely
treats them as byte sequences, not text.  Non-ASCII database names work fine
if every client program uses the same encoding; otherwise, they create the
trouble you're experiencing.  Avoid non-ASCII role names, too, for the same
reasons.

[1] https://www.postgresql.org/message-id/CA%2BOCxozjhM5wAj84vjRNWX5TLEYEMYeh37U%3DibJt22m5nqtJmA@mail.gmail.com
[2] http://get.enterprisedb.com/postgresql/postgresql-9.5.4-2-windows-x64-binaries.zip