[ psqlodbc-Bugs-1000710 ] CHAR field of resultset contains garbled data

Bugs item #1000710, was opened at 2006-08-14 22:00
You can respond by visiting:
http://pgfoundry.org/tracker/?func=detail&atid=538&aid=10007 10&group_id=1000125

Category: None
Group: None
Status: Open
Resolution: None
Priority: 3
Submitted By: Farid Zidan (faridz)
Assigned to: Nobody (None)
Summary: CHAR field of resultset contains garbled data

Initial Comment:
PostgreSQL ODBC Driver 8.02.00.02

resultset for CHAR(8) column contains garbled data.

Example, column cmp_type_cd of the following select ( see attached picture )

Select
"cmp_type_cd", "description", "ctrl_ins_dtm", "ctrl_upd_dtm", "ctrl_usr_id"
from
"in_sync_cmp_type"

Table DDL is:
/*========================================================== ====*/
/* Table: in_sync_cmp_type */
/*========================================================== ====*/
create table in_sync_cmp_type (
cmp_type_cd CHAR(8) not null,
description VARCHAR(30) not null,
ctrl_ins_dtm TIMESTAMP not null default CURRENT_TIMESTAMP,
ctrl_upd_dtm TIMESTAMP not null,
ctrl_usr_id VARCHAR(128) not null,
constraint PK_IN_SYNC_CMP_TYPE primary key (cmp_type_cd)
);


Sample Data:

INSERT INTO in_sync_cmp_type VALUES (
'DATA',
'Data',
'2005-11-18 00:00:00',
'2005-11-18 00:00:00',
'sys');

INSERT INTO in_sync_cmp_type VALUES (
'COL',
'Column',
'2005-12-21 00:00:00',
'2005-12-21 00:00:00',
'sys');
INSERT INTO in_sync_cmp_type VALUES (
'COLM',
'Column',
'2005-12-21 00:00:00',
'2005-12-21 00:00:00',
'sys');

INSERT INTO in_sync_cmp_type VALUES (
'IDX',
'Index',
'2005-12-21 00:00:00',
'2005-12-21 00:00:00',
'sys');
INSERT INTO in_sync_cmp_type VALUES (
'IDXM',
'Index',
'2005-12-21 00:00:00',
'2005-12-21 00:00:00',
'sys');

INSERT INTO in_sync_cmp_type VALUES (
'PK',
'PK',
'2005-12-15 00:00:00',
'2005-12-15 00:00:00',
'sys');
INSERT INTO in_sync_cmp_type VALUES (
'PKM',
'PK',
'2005-12-15 00:00:00',
'2005-12-15 00:00:00',
'sys');

INSERT INTO in_sync_cmp_type VALUES (
'FK',
'FK',
'2005-11-18 00:00:00',
'2005-11-18 00:00:00',
'sys');
INSERT INTO in_sync_cmp_type VALUES (
'FKM',
'FK',
'2005-11-18 00:00:00',
'2005-11-18 00:00:00',
'sys');


INSERT INTO in_sync_cmp_type VALUES (
'PRIV',
'Privilege',
'2005-12-21 00:00:00',
'2005-12-21 00:00:00',
'sys');
INSERT INTO in_sync_cmp_type VALUES (
'PRIVM',
'Privilege',
'2005-12-21 00:00:00',
'2005-12-21 00:00:00',
'sys');

INSERT INTO in_sync_cmp_type VALUES (
'TABLE',
'Tables',
'2005-12-21 00:00:00',
'2005-12-21 00:00:00',
'sys');

INSERT INTO in_sync_cmp_type VALUES (
'FOLDER',
'Folder',
'2006-01-26 00:00:00',
'2006-01-26 00:00:00',
'sys');

INSERT INTO in_sync_cmp_type VALUES (
'TRG',
'Trigger',
'2006-02-28 00:00:00',
'2006-02-28 00:00:00',
'sys');
INSERT INTO in_sync_cmp_type VALUES (
'TRGM',
'Trigger',
'2006-02-28 00:00:00',
'2006-02-28 00:00:00',
'sys');

INSERT INTO in_sync_cmp_type VALUES (
'PROCLS',
'Procedures',
'2006-04-13 00:00:00',
'2006-04-13 00:00:00',
'sys');

INSERT INTO in_sync_cmp_type VALUES (
'TEXT',
'Text',
'2006-05-08 00:00:00',
'2006-05-08 00:00:00',
'sys');

INSERT INTO in_sync_cmp_type VALUES (
'PCOL',
'Procedure/Function Column',
'2006-06-06 00:00:00',
'2006-06-06 00:00:00',
'sys');
INSERT INTO in_sync_cmp_type VALUES (
'PCOLM',
'Procedure/Function Column',
'2006-06-06 00:00:00',
'2006-06-06 00:00:00',
'sys');

------------------------------------------------------------ ----------

>Comment By: Hiroshi Inoue (hinoue)
Date: 2006-08-19 08:30

Message:
What kind of software are you using ?

regards,
Hiroshi Inoue

------------------------------------------------------------ ----------

You can respond by visiting:
http://pgfoundry.org/tracker/?func=detail&atid=538&aid=10007 10&group_id=1000125

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq