insert non-ascii character through DBD-Oracle

From: <dwang999_at_my-deja.com>
Date: 2000/07/02
Message-ID: <8jmnds$8jt$1@nnrp1.deja.com>#1/1

I am using:
1) Oracle 8i Release 2 on Solaris 2.6 running an instance with UTF8 as the character set
2) Perl 5.005_03 built for sun4-solaris 2.7, DBI 1.14, DBD-Oracle-1.03

Problem:
To insert some non-ascii characters within the Perl program I wrote, it returns:
ORA-01756: quoted string not properly terminated (DBD ERROR: OCIStmtPrepare)

The same insert statement entered on the SQLPlus interface works fine.

Does DBD-Oracle support non-ascii chars? How do I solve this problem?

Thanks.

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Sun Jul 02 2000 - 00:00:00 CDT