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

Re: Text as long varchar?

From: Stelios Sfakianakis <ssfak(at)ics(dot)forth(dot)gr>
To: pgsql-odbc(at)postgresql(dot)org
Subject: Re: Text as long varchar?
Date: 2002-08-20 13:07:51
Message-ID: 3D623F27.5040102@ics.forth.gr (view raw or flat)
Thread:
Lists: pgsql-odbc
Janet Borschowa wrote:
> Hi,
> Try using:
> TextAsLongVarchar=1
> Note that there are no spaces around "=".
> 

Yes it works! Thank you very much!
Stelios

> ========================
> Janet Borschowa
> Software Engineer, Database Products                        
> Rogue Wave Software
> (541) 753-1931   FAX: (541) 757-4630
> borschow(at)roguewave(dot)com  http://www.roguewave.com
> 
> 
> -----Original Message-----
> From: Stelios Sfakianakis [mailto:ssfak(at)ics(dot)forth(dot)gr]
> Sent: Monday, August 19, 2002 1:52 AM
> To: pgsql-odbc(at)postgresql(dot)org
> Subject: [ODBC] Text as long varchar?
> 
> 
> Hi,
> I have the following configuration:
>   - PostgreSQL 7.2.1
>   - PostgreSQL odbc driver 7.2.1
>   - Driver Manager: iodbc 3.0.5
>   - OTL <http://members.fortunecity.com/skuchin/home.htm>
>   - FreeBSD 4.6
> I try to read a TEXT column though the OTL's otl_long_string and I get 
> an error because the type of column as returned by the odbc driver seems 
> to be VARCHAR instead of VARCHAR_LONG. Perusing the odbc.postgresql.org 
> site I found in the advanced options section something relative: "Text 
> as LongVarChar: Postgres TEXT type is mapped to SQLLongVarchar, 
> otherwise SQLVarchar"
> So although that this refers to the Win version of the odbc driver I put 
> "TextAsLongVarchar = Yes" in both odbc.ini and odbcinst.ini but without 
> success. The contents of these two files are:
> 
> //odbcinst.ini:
> [ODBC Drivers]
> PostgreSQL = Installed
> 
> [PostgreSQL]
> Description     = PostgreSQL driver for Linux & Win32
> Driver          = /usr/local/lib/libpsqlodbc.so
> Setup           = /usr/local/lib/libpsqlodbc.so
> FileUsage       = 0
> TextAsLongVarchar = Yes
> 
> //odbc.ini:
> [TEST]
> Description = Test Database
> Driver = /usr/local/lib/libpsqlodbc.so
> Trace = Yes
> TraceFile = sql.log
> Database = test
> Servername = localhost
> UserName  =
> Password  =
> Port  = 5432
> Protocol = 6.4
> ReadOnly = No
> RowVersioning = No
> ShowSystemTables = No
> ShowOidColumn = No
> FakeOidIndex = No
> TextAsLongVarchar = Yes
> ConnSettings =
> 
> Any suggestions?
> 
> Thanks for your time
> Stelios
> 



-- 
Thus spake the master programmer:
``After three days without programming, life becomes meaningless.''
		--- The Tao of Programming



In response to

pgsql-odbc by date

Next:From: Andy KelkDate: 2002-08-20 13:42:35
Subject: "Maximum number of conections exceeded" when connnecting via Postgres ODBC
Previous:From: Dave PageDate: 2002-08-20 07:42:54
Subject: Re: PG&VB

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