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


From: "Joel Fradkin" <jfradkin(at)wazagua(dot)com>
To: <pgsql-odbc(at)postgresql(dot)org>
Subject: MaxLongVarcharSize=8190;
Date: 2005-07-21 21:33:35
Message-ID: 000401c58e3b$da093ba0$797ba8c0@jfradkin (view raw, whole thread or download thread mbox)
Lists: pgsql-odbc
When I pulled my connectionstring from the dns builder I got


We had data in our SQL database in text fields longer then 8k.

When a client tried to acces that record we got an error so I upped the
MaxLongVarcharSize=8190; to


This fixed the problem, but I have been told by a conulting group (PCM) that
using over 8 k might be causing my errors.

I did change it back to 8k and am a bit subjective on the outcome (we still
have been having issues, but not odbc related).

Does anyone know the correct settings for my connection string to use longer
then 8k text fields, or do I need to divide the data across multiple


Current settings





Joel Fradkin



pgsql-odbc by date

Next:From: Dave PageDate: 2005-07-22 07:55:57
Subject: Re: MaxLongVarcharSize=8190;
Previous:From: Peter L.Date: 2005-07-21 18:50:48
Subject: Blank varchar and text fields

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