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

Re: Max LongVarChar

From: Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp>
To: Bruce Holt <bj_holt(at)hotmail(dot)com>
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: Max LongVarChar
Date: 2002-12-17 00:31:53
Message-ID: 3DFE7079.6D4A2028@tpf.co.jp (view raw or flat)
Thread:
Lists: pgsql-odbc
Bruce Holt wrote:
> 
>   What is the maximum value for 'Max LongVarChar' within the
>   ODBC Advanced Options (DSN 1/2) dialog box?

There's no max value because the driver itself doesn't
provide any buffer beforehand with the MaxLongVarChar size.
However, most applications seem to have their own text
size limitations.

> What affect does this setting have on
> performance?

It depends on your application. If your application
binds a text item with the MaxLongVarChar sized buffer
,it may unnecessarily consume a large memory.

regards,
Hiroshi Inoue
	http://w2422.nsk.ne.jp/~inoue/

In response to

pgsql-odbc by date

Next:From: srihariDate: 2002-12-17 09:35:11
Subject: Kylix-postgreSQL connectivity
Previous:From: Hiroshi InoueDate: 2002-12-17 00:11:08
Subject: Re: Problem with table name in capitals.

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