From: Adam Rossi <adam.rossi@platinumsolutions.com>
To: pgsql-interfaces@postgresql.org
Subject: Simple Q: Does the ODBC driver support LONGVARCHAR?
Date: Mon, 19 Jun 2000 15:26:39 -0400
Message-ID: <002801bfda24$4f2d2620$0200a8c0@RSGROUP> (raw)
Does the ODBC driver support longvarchar? It seems that no matter what I do
with the settings for the driver, such as checking "Unknowns as
LongVarChar", "Text as LongVarChar", "Parse Statements", etc., the
longvarchar type NEVER works. In this simple SQL statement:
create table test_table
testid INTEGER,
text_field LONGVARCHAR,
var_field VARCHAR(250),
char_field CHAR(1))
the field "text_field" defined as type "LONGVARCHAR" will always cause the
statement to fail with the following message:
ERROR: Unable to locate type name 'longvarchar' in catalog' (#17)
If I change the "LONGVARCHAR" to "TEXT", the statement below works fine:
create table test_table
testid INTEGER,
text_field TEXT,
var_field VARCHAR(250),
char_field CHAR(1))
Since I am relying on some builder tools that only support ODBC standard
types (i.e. LONGVARCHAR and not TEXT), it would make my life a lot easier if
I could get LONGVARCHAR to work. Is this some deficiency in the driver?
Shouldn't an ODBC driver support the major ODBC types? Could anyone point me
in the right direction to hack the driver if it currently does not support
this syntax?
Thanks for your help.
- Adam
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: adam.rossi@platinumsolutions.com
Subject: Re: Simple Q: Does the ODBC driver support LONGVARCHAR?
In-Reply-To: <002801bfda24$4f2d2620$0200a8c0@RSGROUP>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox