Skip site navigation (1) Skip section navigation (2)

UTF-8 support

From: Jean-Michel POURE <jm(dot)poure(at)freesurf(dot)fr>
To: pgsql-odbc(at)postgresql(dot)org, pgsql-hackers(at)postgresql(dot)org
Cc: Tatsuo Ishii <t-ishii(at)sra(dot)co(dot)jp>
Subject: UTF-8 support
Date: 2001-09-23 14:18:36
Message-ID: 4.2.0.58.20010923152820.025d2520@pop.freesurf.fr (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-odbc
Hello,

I have set up a UNICODE database in PostgreSQL 7.1.2 and use psql for 
querying (\ENCODING > UNICODE).
To perform tests, I downloaded code charts from http://www.unicode.org/charts/

1) UTF-8
http://www.postgresql.org/idocs/index.php?app-psql.html explains
"Anything contained in single quotes is furthermore subject to C-like 
substitutions for \n (new line), \t (tab), \digits, \0digits, and \0xdigits 
(the character with the given decimal, octal, or hexadecimal code)."

To start, I would like to store/display a simple 'A' letter in psql, number 
0041, with the following queries:

 > 'INSERT INTO TABLE table_name VALUES (column-name) VALUES ( ' \0041' );
    and then SELECT * FROM table_name. It does not work.
 > Or simply SELECT '\0041'; which does not return 'A'.

Do I miss something?

2) Japanese coding
Do you recommend EUC_JP or UNICODE for storing Japanese text in PostgreSQL?
This is for use in PHP (both for input and display, no recode needed).

3) Is there a way to query available encodings in PostgreSQL for display in 
pgAdmin.
Is it a planned feature in PostgreSQL 7.2? This would be nice if it existed.
Example: function pg_available_encodings -> SQL-ASCII;UNICODE;EUC-JP etc...

Thank you in advance,
Jean-Michel POURE
pgAdmin Team
http://pgadmin.postgresql.org

In response to

Responses

pgsql-hackers by date

Next:From: bpalmerDate: 2001-09-23 17:36:46
Subject: CVS changes
Previous:From: Bruce MomjianDate: 2001-09-23 13:58:47
Subject: Re: CLUSTER TODO item

pgsql-odbc by date

Next:From: Dave PageDate: 2001-09-23 14:39:55
Subject: Re: New driver options in 7.01.0007
Previous:From: Johann ZuschlagDate: 2001-09-23 14:13:31
Subject: Re: New driver options in 7.01.0007

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group