Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2002
    Posts
    2

    Unhappy Unanswered: How to verify the inserted data's character set?

    I create an UTF8 character set Oracle 9i Database. I want to store multilingual data in the db.
    I insert data into db and query the data, found that the data was changed to wrong format.

    How can I query multilingual data correctly using SQL*PLUS or Worksheet? Thanks.

  2. #2
    Join Date
    Apr 2002
    Posts
    188

    Re: How to verify the inserted data's character set?

    Originally posted by stan_lin
    I create an UTF8 character set Oracle 9i Database. I want to store multilingual data in the db.
    I insert data into db and query the data, found that the data was changed to wrong format.

    How can I query multilingual data correctly using SQL*PLUS or Worksheet? Thanks.
    try the following query

    SELECT * FROM sys.props$;

    that could give you a start

  3. #3
    Join Date
    Oct 2002
    Posts
    2

    Red face Re: How to verify the inserted data's character set?

    Originally posted by Maor71
    try the following query

    SELECT * FROM sys.props$;

    that could give you a start

    Thanks for your direction, but it cannot help me in solving my problem.

Posting Permissions

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