[ psqlodbc-Bugs-1000710 ] CHAR field of resultset contains garbled data
От | |
---|---|
Тема | [ psqlodbc-Bugs-1000710 ] CHAR field of resultset contains garbled data |
Дата | |
Msg-id | 20060814220018.AA78986C5EA@pgfoundry.org обсуждение исходный текст |
Список | 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
В списке pgsql-odbc по дате отправления:
Предыдущее
От:Дата:
Сообщение: [ psqlodbc-Bugs-1000709 ] SQLForeignKeys missing FK_NAME missing PK_NAME