UTF-8 support
От | Jean-Michel POURE |
---|---|
Тема | UTF-8 support |
Дата | |
Msg-id | 4.2.0.58.20010923152820.025d2520@pop.freesurf.fr обсуждение исходный текст |
Ответы |
Re: [HACKERS] UTF-8 support
|
Список | pgsql-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
В списке pgsql-odbc по дате отправления: