Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2004
    Location
    Sweden
    Posts
    8

    Unanswered: Storing unicode characters in nvarchar2 field

    I would very much appreciate it if anyone could shed some light on this.

    Don't know if this question is pure Oracle but here we go.

    I want to use MS Access to maintain the contents of tables stored in Oracle 9.2.0.1.0 through linked tables.

    Problem is that any "pure" unicode characters, like chinese characters, is entered in the database as question marks which is turned upside down.

    Is this a problem with my database instance, the odbc connection or Ms Access?

    Database settings
    PARAMETER VALUE
    ------------------------------ ----------------------------------------
    NLS_LANGUAGE AMERICAN
    NLS_TERRITORY AMERICA
    NLS_ISO_CURRENCY AMERICA
    NLS_CHARACTERSET WE8ISO8859P1
    NLS_COMP BINARY
    NLS_LENGTH_SEMANTICS BYTE
    NLS_NCHAR_CONV_EXCP FALSE
    NLS_NCHAR_CHARACTERSET AL16UTF16
    NLS_RDBMS_VERSION 9.2.0.1.0

    ODBC driver is "Oracle in OraHome92" 9.02.00.00.

    MS Access 2003.

  2. #2
    Join Date
    Feb 2004
    Location
    Sweden
    Posts
    8

    Smile Solved: Storing unicode characters in nvarchar2 field

    All,

    problem solved. It was a matter of having an up to date enough ODBC driver.

    /Magnus

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •