Results 1 to 7 of 7
  1. #1
    Join Date
    Oct 2011
    Posts
    4

    Unanswered: inserting Chinese characters using SQL Developer

    hi,

    I'm trying to insert chinese characters into oracle using Oracle SQL Developer


    below are my settings:


    PARAMETER VALUE
    ------------------------------ ----------------------------------------
    NLS_NCHAR_CHARACTERSET AL16UTF16
    NLS_LANGUAGE AMERICAN
    NLS_TERRITORY AMERICA
    NLS_CURRENCY $
    NLS_ISO_CURRENCY AMERICA
    NLS_NUMERIC_CHARACTERS .,
    NLS_CHARACTERSET WE8ISO8859P1
    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_RDBMS_VERSION 11.2.0.2.0




    should i not be able to insert chinese characters into an Nvarchar field?

    i can do it throug the GUI and can also retrieve the inserted characters but i can't use insert statments to insert.

    please advise........


    thanks

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >i can do it throug the GUI and can also retrieve the inserted characters
    above indicates the database is OK
    >but i can't use insert statments to insert.
    then problem exists on client at OS level
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Oct 2011
    Posts
    4
    thanks for your reply anacedent.


    do you know how/what i have to look into to make sure my OS is handling the insert statments as it should in order to insert the Chinese characters correctly?


    thanks

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >do you know how/what i have to look into to make sure my OS is handling the insert statments as it >should in order to insert the Chinese characters correctly?

    Realize that I only know what you post since I am not standing behind you.
    I don't know OS name or version.
    I don't know client software name or version.
    Therefore I can NOT provide any specific solution now.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  5. #5
    Join Date
    Oct 2011
    Posts
    4
    i'm using windows 7 enterprise edition (SP1)

    and intefacing with DB using Oracle SQL Developer V 3.0.04

  6. #6
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    I don't do Windows, so I can not assist any more.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  7. #7
    Join Date
    Oct 2011
    Posts
    4
    thanks for giving it a shot.

    anyone else run into this issue?


    thanks

Posting Permissions

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