Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

[BUGS] BUG #3329: Issue with INSERT INTO for japanese katakana characters.

0 views
Skip to first unread message

Thekkayil Joy Thomas

unread,
Jun 1, 2007, 4:07:03 AM6/1/07
to

The following bug has been logged online:

Bug reference: 3329
Logged by: Thekkayil Joy Thomas
Email address: thekka...@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().

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

0 new messages