PostgreSQL+ Beta bug?
От | Bożena Potempa |
---|---|
Тема | PostgreSQL+ Beta bug? |
Дата | |
Msg-id | MKEIIFDEFPOPHIPFIFJCMEEFDHAA.Bozena.Potempa@otc.pl обсуждение исходный текст |
Список | 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
В списке pgsql-odbc по дате отправления: