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

Re: Bug or not about ASCII and Multi-Byte character set

From: "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk>
To: <Josef(dot)Springer(at)JOOPS(dot)COM>, <zf(dot)tech(at)gmail(dot)com>
Cc: <pgsql-odbc(at)postgresql(dot)org>
Subject: Re: Bug or not about ASCII and Multi-Byte character set
Date: 2005-08-14 20:00:27
Message-ID: 000101c5a10a$d47e0e02$6a01a8c0@valehousing.co.uk (view raw or flat)
Thread:
Lists: pgsql-odbc
As I have said a number of times now, DO NOT USE ASCII FOR NON-ASCII DATA!!!

Whilst some apps like pgAdmin may do what you expect, other apps and interfaces may not.

Instead of ASCII, use the correct encoding for your data, or try Unicode if unsure.

Regards, Dave

-----Original Message-----
From: "Josef Springer"<Josef(dot)Springer(at)JOOPS(dot)COM>
Sent: 14/08/05 18:49:49
To: "ZF"<zf(dot)tech(at)gmail(dot)com>
Cc: "pgsql-odbc(at)postgresql(dot)org"<pgsql-odbc(at)postgresql(dot)org>
Subject: Re: [ODBC] Bug or not about ASCII and Multi-Byte character set

Multibyte characters are written correctly but readed wrong by the ODBC
driver. Seems to work on WinXP clients right. Only Win2k clients may
have this problem. This bug may be corrected in PostgreSQL 8.1.

Josef Springer

ZF wrote:

>version: psqlodbc 08.00.0101 and 08.00.0102
>
>The server database encoding is ASCII in win2000. After inserting several multi-byte characters with pgAdmin3(version: 1.2.1), i found the odbc driver can't provide the right data (application is written in visual c++ and call ODBC API to access db server). All displayed multi-byte char set data were not correct but the ASCII data was right. However, pgAdmin3 can correctly insert and select all data . 
>
>Then i read the "mylog" file and found the multi-byte data have been got correctly from server. 
>Is it possible that some function (maybe the converting function) have a little bug?
>
>
>P.S.
>if the server db encoding is UNICODE and producing a new psqlodbc.dll through  deleting all SQL*W function in 'psqlodbc_win32.def' file, i got Delphi applications using odbc driver can show all right data.
>---------------------------(end of broadcast)---------------------------
>TIP 9: In versions below 8.0, the planner will ignore your desire to
>       choose an index scan if your joining column's datatypes do not
>       match
>

-- 

mit freundlichen GrĂ¼ssen,
Josef Springer
(Gescha"ftsleitung)

<cid:part1(dot)05000701(dot)06060503(at)netscape(dot)com> -- the software company --

Orlando-di-Lasso Str. 2
D-85640 Putzbrunn

Tel. ++49(0)89 600 6920
Fax ++49(0)89 600 69220
mailto Josef(dot)Springer(at)joops(dot)com <mailto:Josef(dot)Springer(at)joops(dot)com>
Website http://www.joops.com





-----Unmodified Original Message-----
Multibyte characters are written correctly but readed wrong by the ODBC
driver. Seems to work on WinXP clients right. Only Win2k clients may
have this problem. This bug may be corrected in PostgreSQL 8.1.

Josef Springer

ZF wrote:

>version: psqlodbc 08.00.0101 and 08.00.0102
>
>The server database encoding is ASCII in win2000. After inserting several multi-byte characters with pgAdmin3(version: 1.2.1), i found the odbc driver can't provide the right data (application is written in visual c++ and call ODBC API to access db server). All displayed multi-byte char set data were not correct but the ASCII data was right. However, pgAdmin3 can correctly insert and select all data . 
>
>Then i read the "mylog" file and found the multi-byte data have been got correctly from server. 
>Is it possible that some function (maybe the converting function) have a little bug?
>
>
>P.S.
>if the server db encoding is UNICODE and producing a new psqlodbc.dll through  deleting all SQL*W function in 'psqlodbc_win32.def' file, i got Delphi applications using odbc driver can show all right data.
>---------------------------(end of broadcast)---------------------------
>TIP 9: In versions below 8.0, the planner will ignore your desire to
>       choose an index scan if your joining column's datatypes do not
>       match
>

-- 

mit freundlichen GrĂ¼ssen,
Josef Springer
(Gescha"ftsleitung)

<cid:part1(dot)05000701(dot)06060503(at)netscape(dot)com> -- the software company --

Orlando-di-Lasso Str. 2
D-85640 Putzbrunn

Tel. ++49(0)89 600 6920
Fax ++49(0)89 600 69220
mailto Josef(dot)Springer(at)joops(dot)com <mailto:Josef(dot)Springer(at)joops(dot)com>
Website http://www.joops.com



Responses

pgsql-odbc by date

Next:From: Peter EisentrautDate: 2005-08-14 20:40:10
Subject: Re: Updates to page on using psqlodbc with Debian
Previous:From: Josef SpringerDate: 2005-08-14 17:45:34
Subject: Re: Bug or not about ASCII and Multi-Byte character set

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