Thread: Text as long varchar?

Text as long varchar?

From
Stelios Sfakianakis
Date:
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



Re: Text as long varchar?

From
Janet Borschowa
Date:
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@roguewave.com  http://www.roguewave.com


-----Original Message-----
From: Stelios Sfakianakis [mailto:ssfak@ics.forth.gr]
Sent: Monday, August 19, 2002 1:52 AM
To: pgsql-odbc@postgresql.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

Re: Text as long varchar?

From
Stelios Sfakianakis
Date:
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@roguewave.com  http://www.roguewave.com
>
>
> -----Original Message-----
> From: Stelios Sfakianakis [mailto:ssfak@ics.forth.gr]
> Sent: Monday, August 19, 2002 1:52 AM
> To: pgsql-odbc@postgresql.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