Skip site navigation (1) Skip section navigation (2)

Re: Issue of Varchar(225) converted to Long datatype by PostGreODBC(Ansi) driver

From: Ludek Finstrle <luf(at)pzkagis(dot)cz>
To: vidisha(dot)shah(at)tcs(dot)com
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: Issue of Varchar(225) converted to Long datatype by PostGreODBC(Ansi) driver
Date: 2006-04-25 12:30:18
Message-ID: 20060425123018.GI23256@soptik.pzkagis.cz (view raw or flat)
Thread:
Lists: pgsql-odbc
> I am using the PostgreODBC(Ansi Driver).
> 
> when I describe the source table, varchar(255) datatype is converted into 
> Long datatype..

There is Max varchar (implicitly 254) in Datasource configuration.
Let's try increase the value. You don't specify OS, psqlodbc version
so I'm unable to give you better advice.

> In one table I have two fields (say c1 and c2) which are varchar(255) in 
> Source Postgre System.they both are converted into Long.Due to which I can 
> not query those two fields simultaneously in my select qyery.
> 
> select c1 from table - works fine
> select c2 from table - works fine
> select c1,c2 from table - does not work

What does it mean "does not work"? What error or problem do you get?

Regards,

Luf

In response to

pgsql-odbc by date

Next:From: Ludek FinstrleDate: 2006-04-25 12:57:02
Subject: Re: Driver could not be loaded (0) SQLSTATE=IM002
Previous:From: Srimathi ChandrasekaranDate: 2006-04-25 12:10:47
Subject: Driver could not be loaded (0) SQLSTATE=IM002

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group