Results 1 to 2 of 2

Thread: character set

  1. #1
    Join Date
    Mar 2005
    Posts
    52

    Unanswered: character set

    Hi,

    I've 2 database with char. set as we8dec and utf8. a new requirement is came resricting to have char. set as "WE8MSWIN1252".

    Can this char. set will be compatibke with the exsisting one.


    Thanks in advance

  2. #2
    Join Date
    Aug 2004
    Location
    France
    Posts
    754
    I don't know which version of Oracle you are running. Here is the piece of documentation you should read (this one is for 10g R1).

    I'm not sure about WE8DEC, but UTF-8 is a superset of WE8MSWIN1252 (Windows Latin-1), so potentially you will lose data when passing from UTF-8 to WE8MSWIN1252. This is explained in the Globalization Support Guide (see the above link). However, if you had only Latin1-compatible data (only characters that exist in Latin-1), you should not lose any data in the process.

    HTH & Regards,

    rbaraer
    ORA-000TK : No bind variable detected... Shared Pool Alert code 5 - Nuclear query ready .

Posting Permissions

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