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

Re: Text as long varchar?

From: Janet Borschowa <borschow(at)roguewave(dot)com>
To: pgsql-odbc(at)postgresql(dot)org
Cc: 'Stelios Sfakianakis' <ssfak(at)ics(dot)forth(dot)gr>
Subject: Re: Text as long varchar?
Date: 2002-08-19 16:46:02
Message-ID: F888C30C3021D411B9DA00B0D0209BE8045452A0@cvo-exchange.cvo.roguewave.com (view raw or flat)
Thread:
Lists: pgsql-odbc
Hi,
Try using:
TextAsLongVarchar=1
Note that there are no spaces around "=".

========================
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



---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

Responses

pgsql-odbc by date

Next:From: Dave PageDate: 2002-08-20 07:42:54
Subject: Re: PG&VB
Previous:From: sangeetha RaoDate: 2002-08-19 16:41:04
Subject: PG&VB

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