<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
Hi,<br>
<br>
I used:<br>
<br>
Debian Sarge with PostgreSQL 7.4.7<br>
My application on Win XP SP2<br>
ODBC-driver: 08.01.1003<br>
<br>
More or less the same problem with LATIN1 (server) and UNICODE (client)<br>
but PgAdminIII doesn't show <b>äöüß</b> later.<br>
<span class="150583209-04082005"></span><br>
Regards<br>
<br>
Johann<br>
<br>
Josef Springer schrieb:<br>
<br>
<blockquote cite="mid42F1AFEC(dot)1020906(at)joops(dot)com" type="cite"> Using no
vovels (umlaut) work fine. But using a vovel, curious effect.<br>
I have tried all server and client variations with sense with this
result. All tests are done with a string column containing <b>äöüß</b><br>
<table border="1" cellpadding="2" cellspacing="2" width="100%">
<tbody>
<tr>
<td valign="top">Server database encoding<br>
</td>
<td valign="top">Client encoding<br>
</td>
<td valign="top">Result<br>
</td>
</tr>
<tr>
<td valign="top">LATIN<br>
</td>
<td valign="top">LATIN<br>
</td>
<td valign="top">Writing works. Reading gets the bytearray
63.63,0,1,0,2,47,0<br>
</td>
</tr>
<tr>
<td valign="top">LATIN<br>
</td>
<td valign="top">UNICODE</td>
<td valign="top">Reading works bur witing gets an error 'Bad
code xxx for UNICODE'<br>
</td>
</tr>
<tr>
<td valign="top">UNICODE<br>
</td>
<td valign="top">UNICODE<br>
</td>
<td valign="top">Writing works. Reading gets the bytearray
63.63,0,1,0,2,47,0<br>
</td>
</tr>
<tr>
<td valign="top">UNICODE<br>
</td>
<td valign="top">LATIN<br>
</td>
<td valign="top">Writing works. Reading gets the bytearray
63.63,0,1,0,2,47,0<br>
</td>
</tr>
<tr>
<td valign="top">UNICODE<br>
</td>
<td valign="top">WIN1250<br>
</td>
<td valign="top">Writing works. Reading gets the bytearray
63.63,0,1,0,2,47,0</td>
</tr>
<tr>
<td valign="top">SQL_ASCII<br>
</td>
<td valign="top">UNICODE<br>
</td>
<td valign="top">Writing works. Reading gets the bytearray
63.63,0,1,0,2,47,0<br>
</td>
</tr>
</tbody>
</table>
<br>
</blockquote>
<b>In PgAdminIII the column is displayed correct in all server database
variations !</b><br>
<br>
</body>
</html>