Lists: | pgsql-odbc |
---|
From: | Johann Zuschlag <zuschlag2(at)online(dot)de> |
---|---|
To: | Hiroshi Inoue <inoue(at)tpf(dot)co(dot)jp>, Dave Page <dpage(at)vale-housing(dot)co(dot)uk>, pgsql-odbc(at)postgresql(dot)org |
Subject: | test results psqlodbc driver 7.02.262 |
Date: | 2006-04-07 18:04:40 |
Message-ID: | 4436A9B8.1010005@online.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-odbc |
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
From: | Johann Zuschlag <zuschlag2(at)online(dot)de> |
---|---|
To: | |
Cc: | Hiroshi Inoue <inoue(at)tpf(dot)co(dot)jp>, Dave Page <dpage(at)vale-housing(dot)co(dot)uk>, pgsql-odbc(at)postgresql(dot)org |
Subject: | test results Win ME with psqlodbc driver 7.02.262 |
Date: | 2006-04-10 18:48:32 |
Message-ID: | 443AA880.2070605@online.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-odbc |
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