changing character set!!
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: changing character set!!

Hybrid View

  1. #1
    Join Date
    Mar 2009
    Posts
    4

    changing character set!!

    Export done in EL8MSWIN1253 character set and AL16UTF16 NCHAR character set
    server uses EL8ISO8859P7 character set (possible charset conversion)

    how could i change characetr set and meet server's environmental variables???would that affect the database??

  2. #2
    Join Date
    Jan 2009
    Posts
    2
    Changing the Database Character Set of an Existing Database

    Database character set migration has two stages:

    1. Data scanning -- can identify number of schema objects where the column widths need to be expanded and the extent of the data that does not exist in the target character repertoire (range). This information helps to determine the best approach for converting the database character set.

    2. Data conversion -- ensure if the database does not contain any of the inconsistencies described in "Character Set Conversion Issues"


    Also refer.
    Doc ID: 261871.1 Changing EL8ISO8859P7 to EL8MSWIN1253
    Last edited by rtnataraj; 04-20-2009 at 03:00 AM.

  3. #3
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    Quote Originally Posted by rtnataraj View Post
    Changing the Database Character Set of an Existing Database

    Database character set migration has two stages:

    1. Data scanning -- can identify number of schema objects where the column widths need to be expanded and the extent of the data that does not exist in the target character repertoire (range). This information helps to determine the best approach for converting the database character set.

    2. Data conversion -- ensure if the database does not contain any of the inconsistencies described in "Character Set Conversion Issues"


    Also refer.
    Doc ID: 261871.1 Changing EL8ISO8859P7 to EL8MSWIN1253
    Are you really suggesting to change Database character set to solve an export issue?

    Please don't!

    Do this...

    export NLS_LANG=EL8ISO8859P7
    run your export
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

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