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