Re: psqlodbclibpq 8_1_03 unicode problem

Well my name is mud at the moment (had a huge problem during my conversion
related to a bad backup that I did not catch until too late).

Hopefully the upcoming year on what is a big step in the right direction
will wash some of the mud away and my client base will be happy in the end.

I do not know if it is my imagination, but the servers seem to be running
with better response times then before, but from what I read on the test ran
by folks who were benchmarking I thought the new driver was a tad slower
then the old one.

Could be the problems I was having with the odbc causing the crashes etc
were in some way impacting the performance and even though the new drivers
are supposed to be slower in my case there was an increase in performance.

In any case as long as I do not see a catastrophic error or an odbc related
issue I will be dancing for joy.

I can not thank everyone who has made contributions on this enough. I know
it was a great many folks, so to each and every one who helped thanks a
bunch!

Joel Fradkin


-----Original Message-----
From: Merlin Moncure [mailto:merlin.moncure@rcsonline.com]
Sent: Wednesday, August 10, 2005 12:07 PM
To: Joel Fradkin
Cc: pgsql-odbc@postgresql.org
Subject: RE: [ODBC] psqlodbclibpq 8_1_03 unicode problem

> Not sure why your getting that.
> Is the database Unicode?
> When I was in SQLASCII mine read as ?
> The older driver 7.4 reas SQLASCII ok and presented French characters
ok,
> but newer version did not.
> When I converted to a Unicode database I could read the French
characters
> ok
> with the new driver.
>
> By the way been up Since Monday no odbc errors yet :)
>
> Joel Fradkin

Great news, Joel!  I think you are over the hump...you just happened to
jump onto the odbc driver at the worst possible moment (during a big
push to update it after a couple of years of relative neglect).

I think it's fair to say you exhibited a certain amount of bravery for
sticking it out over a few difficult weeks.  Now that you have an
application stack you can rely on, you will find that PostgreSQL is an
excellent foundation to build a business around.  The capabilities of
the database far exceed all others in its class.

Merlin