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

experimental Unicode support

From: Jon Willeke <willeke(at)users(dot)sourceforge(dot)net>
To: pgsql-odbc(at)postgresql(dot)org
Subject: experimental Unicode support
Date: 2004-02-02 23:23:11
Message-ID: 20040202232202.D62FF790@mail.intersystems.com (view raw or flat)
Thread:
Lists: pgsql-odbc
I'm attaching a few tweaks to build psqlodbc with Unicode support on 
Unix.  I changed some code that assumes two-byte SQLWCHAR and I changed 
configure.ac and Makefile.am, as necessary.

I tested this with unixODBC 2.2.7 on SuSE Linux 8.2.  I built unixODBC 
--with-iconv-ucode-enc=UCS-4LE and with SQL_WCHART_CONVERT defined, so that 
SQLWCHAR is wchar_t.  I have not tested it with UCS-2 / unsigned short.

I also tested this with iODBC 3.51.1, which always uses wchar_t on Unix.

One caveat, if anyone actually plays with this: sqlext.h should include 
sqlucode.h, so I haven't patched psqlodbc to do so.  The next release of 
unixODBC will contain this fix, and I've mentioned it to the iODBC maintainer.

I realize that the demand for Unicode ODBC on Unix for PostgreSQL is pretty 
small.  Nonetheless, I've learned a few things poking around the code, and 
I figured someone might be interested.

Attachment: psqlodbc-uni.patch.gz
Description: application/octet-stream (3.1 KB)

pgsql-odbc by date

Next:From: Tom LaneDate: 2004-02-03 03:20:54
Subject: Re: catch password on Postgres server
Previous:From: Bing DuDate: 2004-02-02 22:30:05
Subject: Re: catch password on Postgres server

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