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

Re: unicode vs non-unicode ODBC driver

From: Hiroshi Inoue <inoue(at)tpf(dot)co(dot)jp>
To: the6campbells <the6campbells(at)gmail(dot)com>
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: unicode vs non-unicode ODBC driver
Date: 2010-01-13 09:36:43
Message-ID: 4B4D942B.7040403@tpf.co.jp (view raw or flat)
Thread:
Lists: pgsql-odbc
the6campbells wrote:
> 
> Consider a simple scenario.
> 
> CREATE DATABASE "TEST1"
>   WITH OWNER = postgres
>        ENCODING = 'WIN1252'
>        LC_COLLATE = 'English, United States'
>        LC_CTYPE = 'English, United States'
>        CONNECTION LIMIT = -1;
> 
> CREATE TABLE z
> (
>   c1 character(6)
> )
> 
> If you invoke sqlColumns the data type returned from the column changes 
> depending on if you used the UNICODE or non-UNICODE driver. This is with 
> the 8.04.01 driver.
> 
> Get Data All:
> "TABLE_QUALIFIER", "TABLE_OWNER", "TABLE_NAME", "COLUMN_NAME", 
> "DATA_TYPE", "TYPE_NAME", "PRECISION", "LENGTH", "SCALE", "RADIX", 
> "NULLABLE", "REMARKS", "COLUMN_DEF", "SQL_DATA_TYPE", 
> "SQL_DATETIME_SUB", "CHAR_OCTET_LENGTH", "ORDINAL_POSITION", 
> "IS_NULLABLE", "DISPLAY_SIZE", "FIELD_TYPE", "AUTO_INCREMENT", "PHYSICAL 
> NUMBER", "TABLE OID", "BASE TYPEID"
> "TEST1", "public", "z", "c1", 1, "bpchar", 6, 6, <Null>, <Null>, 1, "", 
> <Null>, 1, <Null>, 12, 1, <Null>, 6, 1042, 0, 1, 45819, 0
> 1 row fetched from 24 columns.

It returns SQL_CHAR(=1).

> Get Data All:
> "TABLE_QUALIFIER", "TABLE_OWNER", "TABLE_NAME", "COLUMN_NAME", 
> "DATA_TYPE", "TYPE_NAME", "PRECISION", "LENGTH", "SCALE", "RADIX", 
> "NULLABLE", "REMARKS", "COLUMN_DEF", "SQL_DATA_TYPE", 
> "SQL_DATETIME_SUB", "CHAR_OCTET_LENGTH", "ORDINAL_POSITION", 
> "IS_NULLABLE", "DISPLAY_SIZE", "FIELD_TYPE", "AUTO_INCREMENT", "PHYSICAL 
> NUMBER", "TABLE OID", "BASE TYPEID"
> "TEST1", "public", "z", "c1", -8, "bpchar", 6, 12, <Null>, <Null>, 1, 
> "", <Null>, -8, <Null>, 12, 1, <Null>, 6, 1042, 0, 1, 45819, 0
> 1 row fetched from 24 columns.

It returns SQL_WCHAR(=-8).

regards,
Hiroshi Inoue


In response to

pgsql-odbc by date

Next:From: Jonah H. HarrisDate: 2010-01-13 19:48:21
Subject: Re: Hi!
Previous:From: Hiroshi InoueDate: 2010-01-13 05:35:34
Subject: Re: C# w/ ODBC, 2.1 million list select gives empty DataSet

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