Re: Migration from sqlserver to oracle 8i: character set conversionproblems

From: DA Morgan <damorgan_at_exesolutions.com>
Date: Tue, 18 Feb 2003 08:51:48 -0800
Message-ID: <3E5264A4.43851893_at_exesolutions.com>


Irmen de Jong wrote:

> DA Morgan wrote:
>
> > This has nothing to do with column types, VARCHAR2 or NVARCHAR. It has
> > to do with the character set of the database.
>
> The database config itself is ok, because I can store and retrieve
> unicode characters just fine by using a test Java program that
> accesses the oracle destination database directly trough the JDBC
> driver. Storing € and retrieving it works perfectly (I checked the
> character code that is returned, this is 0x20ac, and that is
> the unicode code for the € symbol).
>
> So I don't think it is a database character set issue.
>
> Irmen de Jong

[Quoted] Well it definitely isn't the fact that Oracle is using VARCHAR2. What else is in the path between the database and the front-end?

Daniel Morgan Received on Tue Feb 18 2003 - 17:51:48 CET

Original text of this message