Re: PsqlODBC and SQLDescribeCol

Re: PsqlODBC and SQLDescribeCol

Andy Hallam wrote:
> 
> PostgreSQL - 7.1.3  (installed on Linux 2.4.2-2)
> PSQLODBC.DLL - 07.01.0007
> Visual C++ - 6.0
> 
> SQLDescribeCol() does not return the correct meta data results.
> 
> The seventh argument to SQLDescribeCol - SQLUINTEGER *ColumnSizePtr - should
> return the size of the column.
> 
> SQLDescribeCol works fine under SQLSERVER, DB2 and ORACLE. i.e using the
> below schema I get 20 returned in ColumnSizePtr, but, under PostgreSQL I get
> 254 ??? - Also, I get 254 no matter what size I make mytable.mycolumn
> 
> CREATE TABLE mytable
> (
>  mycolumn NCHAR VARYING (20)
> )
> 
> If I change the mytable.mycolumn data type from NCHAR VARYING (20) ->
> CHARACTER (20) ColumnSizePtr returns 3. !!!

Hmm strange, I get 20 here.
Could you send me the mylog output ?
There's a driver option which enable/disables the mylog
output.

regards,
Hiroshi Inoue