Postgres Pro
Downloads
Home   >   mailing lists

BUG #3329: Issue with INSERT INTO for japanese katakana characters. - Mailing list pgsql-bugs

From Thekkayil Joy Thomas
Subject BUG #3329: Issue with INSERT INTO for japanese katakana characters.
Date
Msg-id 200706010547.l515lN7e041078@wwwmaster.postgresql.org
Whole thread Raw
List pgsql-bugs
Tree view 
The following bug has been logged online:

Bug reference:      3329
Logged by:          Thekkayil Joy Thomas
Email address:      thekkayiljoy@gmail.com
PostgreSQL version: 08.02.0100
Operating system:   Windows 2000 Server Japanese
Description:        Issue with INSERT INTO for japanese katakana characters.
Details:

INSERT INTO statement fails through SQLExecDirect() for a varchar field
where the value ends with japanese katakana character tsu 'ツ'

I tried to run a statement from the application(VC 7 win32 console
application).

INSERT INTO Sample_TABLE (Field1) Values('禁止されたコンテンツ');

This fails. The result persist for any other japanese string ending with
'ツ'.

I'm using odbc driver 'psqlodbc35w.dll' of 8.2.1.0 version. I upgraded it to
8.2.4.0. Still no change.

The server_encoding is set to UTF8. Client_encoding is set to UNICODE in the
database.

However the insertion is successful while trying to insert from pgadmin.exe.
And the same fails using SQLExecDirect().

pgsql-bugs by date:

Previous
From: "Sergey Morgalev"
Date:
Subject: BUG #3328: initialization complex types with domain column
Next
From: Frank van Vugt
Date:
Subject: minor issue - one semicolumn too many in the docs