Обсуждение: MS Access, UNICODE, ODBC

Поиск
Список
Период
Сортировка

MS Access, UNICODE, ODBC

От
bernsteine@who.int
Дата:

We have a problem inserting data into Postgres in UNICODE using the MS Access 2003 as a front-end.

I am not entirely clear on the source of the problem we have.

Our Postgres DB is in UNICODE, I have converted it and tested. I can insert and display Cyrilic and Arabic characters using PhpPgAdmin 3.5 version.

The MS Access 2003, seems to be able to store UNICODE and display it fine alone too.

It is only when we use Access as a front end to Postgres that we have garbage displayed in Access retreived from Postgres and Postgres data gets corrupted. Which led us to believe that it is ODBC config issue.

Please, help.

Eugene Bernstein

Database Administrator

(WHO/EIP/KMS)

WHO/OMS HQ,

20 Avenue Appia,

1211 Geneva 27,

Switzerland

bernsteine@who.int

direct +41.22.791.2447

fax +41.22.791.4806