Skip site navigation (1) Skip section navigation (2)

UTF encoding (win32) ?

From: Rainer Bauer <usenet(at)munnin(dot)com>
To: pgsql-odbc(at)postgresql(dot)org
Subject: UTF encoding (win32) ?
Date: 2005-10-26 13:07:54
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-odbc
Hello Dave,

I am currently adding support for pgsql for my win32 application. Server is
running on win2k, client on Win9x.

I tested it with the 8.0 version and created a UNICODE database. The data
transfered from and to the database is LATIN1 encoded (WIN1252, to be precise,
but support for that codepage was only added in pgsql 8.1). Using the
08.00.0102 ODBC driver I ran into massive problems, but I have read that the
new drivers have adressed this issue.

After some time trying to read/write the data correctly, I found out that I
had to execute "SET CLIENT_ENCODING TO 'UNICODE'" after the connection was
established (and additionally convert the text to UTF-8 when sending data).

But: When I alter text in the database using an UPDATE command, then no
conversion is applied!
Example: UPDATE table_name SET col_text='äöü' WHERE (...)

Now this text goes straight into the database LATIN1 encoded. When I convert
it to UTF-8 then the text stored in the database is "rubbish" and will be
returned as "rubbish".

Is this behaviour by design? Or is the text converted to UTF-8 somwhere on its
way and I just don't see it?

And another question: Which ODBC driver will be shipped with the final pgsql
version 8.1?

And finally: Is it possible to get precompiled driver DLL's for the current
snapshots? Do I only have to replace the psqlodbc.dll or is it necessary to
update any registry keys?

I think that should be enough for my first post here.


PS: I have installed pgsql 8.1-beta4 now, but wanted to adress the ODBC issues
before doing any further testing.

pgsql-odbc by date

Next:From: Merlin MoncureDate: 2005-10-26 13:25:25
Subject: Re: versions of oDBC driver
Previous:From: Zlatko MatićDate: 2005-10-26 12:48:57
Subject: Re: [ODBC] versions of oDBC driver

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group