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

unicode vs non-unicode ODBC driver

From: the6campbells <the6campbells(at)gmail(dot)com>
To: pgsql-odbc(at)postgresql(dot)org
Subject: unicode vs non-unicode ODBC driver
Date: 2010-01-12 23:48:56
Message-ID: 22431f1b1001121548q64dcdeb0j3e0aed7b69e8336a@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-odbc
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.


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.

Responses

pgsql-odbc by date

Next:From: Craig RingerDate: 2010-01-13 04:41:47
Subject: Re: C# w/ ODBC, 2.1 million list select gives empty DataSet
Previous:From: Laurent ChouinardDate: 2010-01-11 23:34:25
Subject: C# w/ ODBC, 2.1 million list select gives empty DataSet

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