From: | Bożena Potempa <Bozena(dot)Potempa(at)otc(dot)pl> |
---|---|
To: | <pgsql-odbc(at)postgresql(dot)org> |
Subject: | PostgreSQL+ Beta bug? |
Date: | 2002-11-15 16:24:43 |
Message-ID: | MKEIIFDEFPOPHIPFIFJCMEEFDHAA.Bozena.Potempa@otc.pl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
Dear Authors of PostgreSQL ODBC driver,
I am trying to use PostgreSQL+ Beta driver on Windows 2000.
It works very well with one exception. When I try to
insert a char value including 0 then the remaing characters
are lost. And example:
simple table: create table t (fc varchar(5))
The program code (runable in MS VC++ 6.0):
// connect and allocate a statement handle hstmt
HSTMT hstmt;
RETCODE rc;
char fc[5];
SQLINTEGER fcl;
rc = SQLPrepare(hstmt, "insert into t values(?)", SQL_NTS);
rc = SQLBindParameter(hstmt, 1, SQL_PARAM_INPUT, SQL_C_CHAR,
SQL_VARCHAR, 5, 0, fc, sizeof(fc), &fcl);
fc[0]=1;
fc[1]=0;
fc[2]='a';
fcl=3; /* string length */
rc = SQLExecute(hstmt);
// disconnect
-----
After this please check in psql:
select ascii(substring(fc,1,1)) from t; - 1, OK
select ascii(substring(fc,2,1)) from t; - 0, OK
select ascii(substring(fc,3,1)) from t; - 0 - lost value 'a'
Please let me know if this is a known bug and what is the possibility
of fixing this.
Best regards,
Bozena Potempa
OTC
Poland
From | Date | Subject | |
---|---|---|---|
Next Message | Karl Swisher | 2002-11-15 17:34:57 | Access Linked Tables |
Previous Message | markw | 2002-11-15 16:21:58 | Threading crash using ODBC |