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

Re: MaxLongVarcharSize=8190;

From: "Joel Fradkin" <jfradkin(at)wazagua(dot)com>
To: "'Dave Page'" <dpage(at)vale-housing(dot)co(dot)uk>,<pgsql-odbc(at)postgresql(dot)org>
Cc: <ac(at)wazagua(dot)com>
Subject: Re: MaxLongVarcharSize=8190;
Date: 2005-07-22 16:01:31
Message-ID: 000401c58ed6$a1065720$797ba8c0@jfradkin (view raw or flat)
Thread:
Lists: pgsql-odbc
 

I am concerned about trying to convert to unicode and the new drivers again,
because last time my tests went smoth (using the non libpq driver) and in
production it fell like a punctured blimp. I wasted like 18hours of my time
(not totally least I have a current data set in unicode to test with).

 

In what way? Is that what was crashing in the night?

 

I am not sure what was crashing us at night (or daytime for that matter).

Interestingly the catastrophic error I got when I had the permissions wrong
for debug is the same one we got most of the time, so maybe its something
weird with permissions.

 

I did test the libpq driver with the SQLASCII and found it displays ? marks,
so I guess I have to convert to Unicode (which is what I wanted to do anyway
to make sure upper and length etc work properly).

 

I also tested various lengths of text with both the older driver (seems to
be 100k limit before the record set complains in asp) and newest libpq (did
not seem to mind any length tested with a 1 meg text test data insertion and
editing in asp). In my connect string in both cases (older and newer
driver)I had the max length 

 

Current settings

MaxVarcharSize=254;MaxLongVarcharSize=16280;
TextAsLongVarchar=1;UnknownsAsLongVarchar=0;

 

set to 16K so I guess that is not what determines what the recordeset can
work with.

 

So far only good news on the testing of the new driver. I will try to get a
production box (2 proc 2650 4 meg) up for IIS and set up a test Unicode
database on my 4 proc Dell redhat postgres box for doing a bit more in deph
testing next week.

 

Joel

In response to

pgsql-odbc by date

Next:From: Ets ROLLANDDate: 2005-07-22 17:21:13
Subject: Row versionning between MS-Access and PostgreSQL 8
Previous:From: Dave PageDate: 2005-07-22 15:42:48
Subject: Re: Static analysis run

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