Re: Unicode in Oracle

On Dec 3, 2007 5:20 AM, Morten <morten@xxxxxxxxxxxx> wrote:
> Hi
>
> I have trouble inserting for example an euro sign into an Oracle UTF-16
> field.
> When I do this:
> update tblcontent set data = '?1' where id=1;
> , the following data is inserted:
> 0,ac,0,31 -- output from dump(DBMS_LOB.SUBSTR(data,100), 1016)
> It should be
> 20,ac,0,31.
>
> I have tried starting up with -Dfile.encoding=UTF-8 but to no avail.
>
> I'm using Squirrel 2.6.1. The Oracle DB is 10g.
>
> Is there something I can do to make it work?

My understanding is that there are a couple of approaches to use
unicode in Oracle (database and datatype) :

http://www.oracle.com/technology/oramag/oracle/03-nov/o63tech_glob.html

What is your database charset and what does your table declaration look like?

Rob

-------------------------------------------------------------------------
SF.Net email is sponsored by: The Future of Linux Business White Paper
from Novell.  From the desktop to the data center, Linux is going
mainstream.  Let it simplify your IT future.
http://altfarm.mediaplex.com/ad/ck/8857-50307-18918-4