How to change the oracle charset?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: How to change the oracle charset?

  1. #1
    Join Date
    Sep 2001
    Posts
    99

    How to change the oracle charset?

    I have a oracle 8.1.6,using the US7ASICC charset, I want to change the charset to ZH16GBK(chinese encode),but when I changed,the old data is code disorder.The old data is the Chinese Text.After changed the charset,the data read is "???",so I have to change the charset to US7ASICC.
    How can I changed the charset ?
    ocean

  2. #2
    Join Date
    Nov 2002
    Posts
    39
    I think, there is no way to change the existing characters with the new characterset even if you recreate the database with the new characterset. Only way is to identify the '?' characters and run some patch to update with the new, after you create the database with new characterset.
    Sathish

  3. #3
    Join Date
    Sep 2001
    Location
    Düsseldorf, Germany.
    Posts
    588
    you can change character set of database, but you need to re-import your data, because existing characters won't change...

    http://oracle.ittoolbox.com/document...ent.asp?i=1601

    HTH

    Sameer

Posting Permissions

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



Click Here to Expand Forum to Full Width