From: | <noreply(at)pgfoundry(dot)org> |
---|---|
To: | noreply(at)pgfoundry(dot)org |
Subject: | [ psqlodbc-Bugs-1000710 ] CHAR field of resultset contains garbled data |
Date: | 2006-08-14 22:00:18 |
Message-ID: | 20060814220018.AA78986C5EA@pgfoundry.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | yapand | 2006-08-15 04:35:03 | whitch compiler do you choose. |
Previous Message | noreply | 2006-08-14 21:23:36 | [ psqlodbc-Bugs-1000709 ] SQLForeignKeys missing FK_NAME missing PK_NAME |