Re: question marks on insert of Unicode Japanese text with Perl
Posted by: Shuichi Tamagawa
Date: August 23, 2005 07:40PM

Hi Dan,

The byte sequence of 'カラー' in utf8 encoding is E382AB E383A9 E383BC.
Utf8 is one of the encoding methods to put the characters defined by ISO/IEC 10646(so-called Unicode) into byte sequence. And 30AB 30E9 30FC is the byte sequence of 'カラー' in UCS2 encoding.

Try my $sth = $dbh->prepare("insert into t (kw) values (0xE382ABE383A9E383BC)");
It should be fine.

Regards.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: question marks on insert of Unicode Japanese text with Perl
3952
August 23, 2005 07:40PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.