test results psqlodbc driver 7.02.262

Set-up:
PostgreSQL 7.4.X -- Debian Sarge
Windows application -- psqlodbc+ 7.02.0262 -- Win XP Sp2
Protocol: 7.4+

locale:
ISO-8859-15

backend:
a) LATIN9
b) UNICODE

Operation:
Reading and writing (SELECT, INSERT, UPDATE)

Data used:
complete ISO-8859-15 character set (0x20-0xFF, without unprintable
characters)

Data types used:
varchar(40) and text

Errors:
were not observed during tests

Former errors:
-- sporadic errors when leaving application:
were not observed during tests

-- error 'unknown configuration parameter "max_identifier_length"':
was not observed during tests

Remarks:
the PostgreSQL log is filling up with -'Error: Typ "lo" is not
existing'- lines.

Result:
success

Regards,
Johann


---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

test results Win ME with psqlodbc driver 7.02.262

Hi Hiroshi,

I did some test with Win ME and the same application I used for the
previous tests with XP. Just note that my application is quite old and
was developed for Win NT and Win 98. Before the psqlodbc+ driver came on
the scene I was forced to use the ANSI-Version of the driver 8.01.XX.

Set-up is the same as before (ME instead of XP -- Debian Sarge -- PG
7.4.X). I tested with LATIN9 and UNICODE database, verified with psql
and pgAdmin (using XP of course).

Again I tested the complete ISO-8859-15/Latin9 character set ( 0x20 to
0xFF without unprintable char.). It worked, excluding the bytes 0xA6,
0xA8, 0xB4, 0B8, 0xBC, 0xBD, 0xBE. Obviously my application was written
for ISO-8859-1/Latin1 with just the Euro-character added (0xA4). The
same occurred on Win XP. But I didn't noticed during the first tests. It
seems, my application just can't read these bytes, since checking the
same data through pgAdmin doesn't show any errors.

Please also not that I just used an updated version of Win ME and but
didn't update the driver manager. I also didn't use "set client_encoding
to XXX". But the driver functioned smoothly with LATIN9 and UNICODE
database. Also, no crashes occurred.

IMHO we don't need two different driver versions any more. Good job,
Hiroshi (Inoue and Saito)!

Any comments? Questions? Any further tests required?

Regards,
Johann


---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

Re: test results Win ME with psqlodbc driver 7.02.262

=20

> -----Original Message-----
> From: Johann Zuschlag [mailto:zuschlag2@online.de]=20
> Sent: 10 April 2006 19:49
> Cc: Hiroshi Inoue; Dave Page; pgsql-odbc@postgresql.org
> Subject: test results Win ME with psqlodbc driver 7.02.262
>=20
> IMHO we don't need two different driver versions any more.=20
> Good job, Hiroshi (Inoue and Saito)!
>=20
> Any comments? Questions? Any further tests required?

Johann - many thanks for putting in the time to run these tests. As you
may have seen, Hiroshi's code is now at CVS-tip, so the 08.02 driver
will be based on it.

Regards, Dave.

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend