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