[ psqlodbc-Bugs-1000710 ] CHAR field of resultset contains garbled data - Mailing list pgsql-odbc

Bugs item #1000710, was opened at 2006-08-14 18:00
You can respond by visiting:
http://pgfoundry.org/tracker/?func=detail&atid=538&aid=1000710&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');

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

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