Re: Inserting/Updating Unicode Data

On Sep 10, 12:13 pm, rob <rob_pan..._at_asdsoftware.com> wrote:
> Joel,
>
> Thanks for you reply.
>
> Here are my NLS parameters:
> =====================
> PARAMETER       VALUE
> NLS_LANGUAGE    AMERICAN
> NLS_TERRITORY   AMERICA
> NLS_CURRENCY    $
> NLS_ISO_CURRENCY        AMERICA
> NLS_NUMERIC_CHARACTERS  .,
> NLS_CHARACTERSET        WE8MSWIN1252
> NLS_CALENDAR    GREGORIAN
> NLS_DATE_FORMAT DD-MON-RR
> NLS_DATE_LANGUAGE       AMERICAN
> NLS_SORT        BINARY
> NLS_TIME_FORMAT HH.MI.SSXFF AM
> NLS_TIMESTAMP_FORMAT    DD-MON-RR HH.MI.SSXFF AM
> NLS_TIME_TZ_FORMAT      HH.MI.SSXFF AM TZR
> NLS_TIMESTAMP_TZ_FORMAT DD-MON-RR HH.MI.SSXFF AM TZR
> NLS_DUAL_CURRENCY       $
> NLS_COMP        BINARY
> NLS_LENGTH_SEMANTICS    BYTE
> NLS_NCHAR_CONV_EXCP     FALSE
> NLS_NCHAR_CHARACTERSET  AL16UTF16
> NLS_RDBMS_VERSION       9.2.0.3.0
>
> We have a .NET application that can run against a SQL Server or Oracle
> 9i / 10g database.  This application allows user to preview data for
> many languages on the same form (using Arial Unicode MS font).  In sql
> server we are not having any issues inserting / previewing data from
> the NVarchar fields, but with Oracle once the data is saved and
> retrieved the the database upside down questons marks are being
> shown.
>
> I don't completely understand why I would have to change the client
> "NLS_LANG", due to the fact that our client is application is a
> unicode app.  I thought the whole point of using "NVarchars" was to
> allow the storing of National characters.
>
> Thanks,
> Rob

Yes, but if you don't set it, you get the default 7 bit american ascii. I think, it's been too long since I've played, please peruse metalink, like Note:227336.1 and the one I said before.

You shouldn't have to go to the extreme Adrian said, though it might make things simpler. Somewhere in the docs it explains when to choose National characters and when to do the whole db character set.

jg

--
@home.com is bogus.
http://www.careerbuilder.com/share/aboutus/pressreleasesdetail.aspx?id=pr459&sd=9%2F10%2F2008&ed=12%2F31%2F2008&siteid=cbpr&sc_cmp1=cb_pr459_&cbRecursionCnt=1&cbsid=e318f79d539149ff96bbf4ba7306f18c-274471815-JR-5