| From: | "Han" <zhouhanok(at)vip(dot)sina(dot)com> |
|---|---|
| To: | Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp> |
| Cc: | pgsql-odbc(at)postgresql(dot)org <pgsql-odbc(at)postgresql(dot)org> |
| Subject: | Re: Problem about Bytea and SQL_C_CHAR |
| Date: | 2002-11-28 08:11:50 |
| Message-ID: | 20021128081129.D7C15475A9E@postgresql.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-odbc |
Hiroshi Inoue,
OK, that crash problem solved. But there are even more datatype conversion problems.
First I prepared an insert statement, bound params all using SQL_C_CHAR and SQL_NTS, and execute it. All type of column values were inserted properly except bytea--it's null in the column.
And then I retrived data from the table I just inserted, binding columns with SQL_C_DEFAULT. Most colums returned wrong value.
Notice that I use SQL_C_CHAR for insert and SQL_C_DEFAULT for retrive.
Please check it. Thanks and regards!
>
>Maybe I found a cause. Please try the snapshot dll again.
>Thanks a lot.
>
>Hiroshi Inoue
> http://w2422.nsk.ne.jp/~inoue/
>
>---------------------------(end of broadcast)---------------------------
>TIP 6: Have you searched our list archives?
>
>http://archives.postgresql.org
Han
zhouhanok(at)vip(dot)sina(dot)com
2002-11-28
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dave Page | 2002-11-28 08:33:12 | Re: ODBC changes |
| Previous Message | Hiroshi Inoue | 2002-11-28 06:36:17 | Re: Problem about Bytea and SQL_C_CHAR |