Re: Unicode in Oracle

On Dec 3, 2007 8:37 AM, Morten <morten@xxxxxxxxxxxx> wrote:
> > 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
> >
> Hi
>
> The field is an NCLOB. The charset is AL16UTF16.
>
> When I manually change the data, it works fine:
> update tblcontent set data=replace(data, unistr('\00ac'), unistr('\20ac'))
>
> So I think the problem is in Squirrel SQL.

Could be; I wanted to make sure I had a similar setup to be able to
see the problem.  How did you insert the data using SQuirreL (meaning,
insert statement or Contents tab or Result tab)?

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