Re: pgaccess - international characters

Поиск
Список
Период
Сортировка
От Lars Bensmann
Тема Re: pgaccess - international characters
Дата
Msg-id 20010714052050.B9290@epost.de
обсуждение исходный текст
Ответ на pgaccess - international characters  (Lars Bensmann <lars.bensmann@epost.de>)
Список pgsql-interfaces
Hello,

On Fri, Jul 13, 2001 at 01:32:22AM +0200, Lars Bensmann wrote:
> 
> Now we have several Windows workstations using pgaccess to enter data into
> several tables. Everything is fine when using forms. International
> characters (like the german umlaute) work fine. But when I open the table
> directly don't get human readable output for the characters. It varies
> from one or several blank characters to "garbage".

I tested this on another box with Debian unstable installed (this includes
PostgreSQL 7.1.2).

When I use psql to enter umlaut characters everything is fine. pg_dump and
gtksql show proper results. Even pgaccess displays the characters
correctly. But when I enter the characters in pgaccess or update a record
I entered with psql I get this "garbage" again.

I examined this a bit more closely and it seems that the characters are
translated like this:

"a: <C3><A4>
"o: <C3><B6>
"u: <C3><BC>
"A: <C3><84>
"O: <C3><96>
"U: <C3><9C>
"s: <C3><9F>

I get the same results when I enter the data using Tksql as suggested by
Sandro.

This seems to be related to tcl or tk. Am I the only one with this
problem? What can I do about this?

TIA,
Lars

-- 
Any time things appear to be going better, you have overlooked something.


В списке pgsql-interfaces по дате отправления:

Предыдущее
От: Sandro Dentella
Дата:
Сообщение: Re: pgaccess - international characters
Следующее
От: Jüri Fjodorov
Дата:
Сообщение: MS Access 97 SR-1, psqlodbc 7.01.00.06, slow perfomance