pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedGetting info on "Max LongVarChar" under ODBC
5+ messages / 2 participants
[nested] [flat]
* Getting info on "Max LongVarChar" under ODBC
@ 2001-07-08 11:36 markMLl.pgsql-interfaces@telemetry.co.uk
2001-07-09 00:01 ` Re: Getting info on "Max LongVarChar" under ODBC Hiroshi Inoue <Inoue@tpf.co.jp>
0 siblings, 1 reply; 5+ messages in thread
From: markMLl.pgsql-interfaces@telemetry.co.uk @ 2001-07-08 11:36 UTC (permalink / raw)
To: pgsql-interfaces
Is there a way of querying the Win-32 ODBC driver to find out the
current value of the "Max LongVarChar" control panel setting?
What I'm trying to do is make a Delphi (via BDE) app aware of the
limitation so that it can behave intelligently rather than risking
truncating text.
Any suggestions much appreciated.
--
Mark Morgan Lloyd
markMLl .AT. telemetry.co .DOT. uk
[Opinions above are the author's, not those of his employers or
colleagues]
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Getting info on "Max LongVarChar" under ODBC
2001-07-08 11:36 Getting info on "Max LongVarChar" under ODBC markMLl.pgsql-interfaces@telemetry.co.uk
@ 2001-07-09 00:01 ` Hiroshi Inoue <Inoue@tpf.co.jp>
2001-07-09 11:35 ` Re: Getting info on "Max LongVarChar" under ODBC markMLl.pgsql-interfaces@telemetry.co.uk
0 siblings, 1 reply; 5+ messages in thread
From: Hiroshi Inoue @ 2001-07-09 00:01 UTC (permalink / raw)
To: markMLl.pgsql-interfaces@telemetry.co.uk; +Cc: pgsql-interfaces
markMLl.pgsql-interfaces@telemetry.co.uk wrote:
>
> Is there a way of querying the Win-32 ODBC driver to find out the
> current value of the "Max LongVarChar" control panel setting?
>
You seem to be able to call SQLGetTypeInfo() though
I'm not sure.
regards,
Hiroshi Inoue
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Getting info on "Max LongVarChar" under ODBC
2001-07-08 11:36 Getting info on "Max LongVarChar" under ODBC markMLl.pgsql-interfaces@telemetry.co.uk
2001-07-09 00:01 ` Re: Getting info on "Max LongVarChar" under ODBC Hiroshi Inoue <Inoue@tpf.co.jp>
@ 2001-07-09 11:35 ` markMLl.pgsql-interfaces@telemetry.co.uk
2001-07-09 23:03 ` Re: Getting info on "Max LongVarChar" under ODBC Hiroshi Inoue <Inoue@tpf.co.jp>
0 siblings, 1 reply; 5+ messages in thread
From: markMLl.pgsql-interfaces@telemetry.co.uk @ 2001-07-09 11:35 UTC (permalink / raw)
To: pgsql-interfaces
Hiroshi Inoue wrote:
> You seem to be able to call SQLGetTypeInfo() though
> I'm not sure.
Many thanks, I obviously need to work out on ODBC programming :-) At
present I'm doing a temporary job by querying the parameter from the
registry- but that will obviously fail if I need to look at an
alternative database.
However, I've now found that even if I change the Max LongVarChar
parameter from its default 8190 to (say) 16382 an attempt to save more
than 8K text still gets truncated. I can work around this for the time
being but would appreciate it if anybody could tell me whether there are
still any outstatding issues.
Hope this isn't an FAQ but I've not found it yet.
Running 7.1.2, I've got a table which amongst other things has a field
declared as TEXT into which I'm saving a script for interpretation on
the client system. On the ODBC driver settings I've got "Unknown Sizes"
as "Longest", "Text as LongVarChar" enabled, and "Max LongVarChar" set
to 16382. I've rebooted after changing the parameters in case they were
only read when the driver was loaded. Client OS is NTW4SP3, ODBC driver
Insight 7.01.0005.
--
Mark Morgan Lloyd
markMLl .AT. telemetry.co .DOT. uk
[Opinions above are the author's, not those of his employers or
colleagues]
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Getting info on "Max LongVarChar" under ODBC
2001-07-08 11:36 Getting info on "Max LongVarChar" under ODBC markMLl.pgsql-interfaces@telemetry.co.uk
2001-07-09 00:01 ` Re: Getting info on "Max LongVarChar" under ODBC Hiroshi Inoue <Inoue@tpf.co.jp>
2001-07-09 11:35 ` Re: Getting info on "Max LongVarChar" under ODBC markMLl.pgsql-interfaces@telemetry.co.uk
@ 2001-07-09 23:03 ` Hiroshi Inoue <Inoue@tpf.co.jp>
2001-07-10 20:55 ` Re: Getting info on "Max LongVarChar" under ODBC markMLl.pgsql-interfaces@telemetry.co.uk
0 siblings, 1 reply; 5+ messages in thread
From: Hiroshi Inoue @ 2001-07-09 23:03 UTC (permalink / raw)
To: markMLl.pgsql-interfaces@telemetry.co.uk; +Cc: pgsql-interfaces@PostgreSQL.org, "pgsql-odbc@postgresql.org" <pgsql-odbc@PostgreSQL.org>
markMLl.pgsql-interfaces@telemetry.co.uk wrote:
>
> Hiroshi Inoue wrote:
>
> > You seem to be able to call SQLGetTypeInfo() though
> > I'm not sure.
>
> Many thanks, I obviously need to work out on ODBC programming :-) At
> present I'm doing a temporary job by querying the parameter from the
> registry- but that will obviously fail if I need to look at an
> alternative database.
>
> However, I've now found that even if I change the Max LongVarChar
> parameter from its default 8190 to (say) 16382 an attempt to save more
> than 8K text still gets truncated. I can work around this for the time
> being but would appreciate it if anybody could tell me whether there are
> still any outstatding issues.
>
Please try the latest driver(7.01.0006).
It removed the text/query length limit.
regards,
Hiroshi Inoue
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Getting info on "Max LongVarChar" under ODBC
2001-07-08 11:36 Getting info on "Max LongVarChar" under ODBC markMLl.pgsql-interfaces@telemetry.co.uk
2001-07-09 00:01 ` Re: Getting info on "Max LongVarChar" under ODBC Hiroshi Inoue <Inoue@tpf.co.jp>
2001-07-09 11:35 ` Re: Getting info on "Max LongVarChar" under ODBC markMLl.pgsql-interfaces@telemetry.co.uk
2001-07-09 23:03 ` Re: Getting info on "Max LongVarChar" under ODBC Hiroshi Inoue <Inoue@tpf.co.jp>
@ 2001-07-10 20:55 ` markMLl.pgsql-interfaces@telemetry.co.uk
0 siblings, 0 replies; 5+ messages in thread
From: markMLl.pgsql-interfaces@telemetry.co.uk @ 2001-07-10 20:55 UTC (permalink / raw)
To: pgsql-interfaces
Hiroshi Inoue wrote:
> Please try the latest driver(7.01.0006).
> It removed the text/query length limit.
<GRIN> It does as well! Many thanks, just what I need :-)
--
Mark Morgan Lloyd
markMLl .AT. telemetry.co .DOT. uk
[Opinions above are the author's, not those of his employers or
colleagues]
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2001-07-10 20:55 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2001-07-08 11:36 Getting info on "Max LongVarChar" under ODBC markMLl.pgsql-interfaces@telemetry.co.uk
2001-07-09 00:01 ` Hiroshi Inoue <Inoue@tpf.co.jp>
2001-07-09 11:35 ` markMLl.pgsql-interfaces@telemetry.co.uk
2001-07-09 23:03 ` Hiroshi Inoue <Inoue@tpf.co.jp>
2001-07-10 20:55 ` markMLl.pgsql-interfaces@telemetry.co.uk
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