Dear Dave,
I used pgsql with PostgreSQL 7.2 and noticed there was an automatic
translation between UTF-8 <-> Latin characters. This is a new feature of
PostgreSQL 7.2.
So fine :
Suppose we have a Unicode database :
\Encoding Latin1 (\same with \Encoding SQL_ASCII does not work)
INSERT INTO table_foo (field_bar) VALUES ('é');
SELECT field_bar FROM table_foo WHERE field_bar='é' works.
I checked the UTF-8 display in Apache, it works.
In the case of an UTF-8 database, it means we need to create and query schema
objects using \Encoding Latin1. Should it be done at ODBC level or at
pgAdmin2 level? What is your opinion?
This could help us display non-multibyte UTF-8 data as well.
Cheers,
Jean-Michel POURE