1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

i have a problem and i hope someone can provides solution

Discussion in 'Security, Backup and Recovery' started by itx005, May 17, 2010.

  1. itx005

    itx005 Active Member

    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    55
    Hi all ,,
    i have a problem and i hope someone can provides solution for it.
    i have a database in the server which is in charachterset AR8iso88p59p6 i want to export these data with convert it to AR8MSWIN1256 .

    the data are displayed as garbage in .NET environment with charachterset AR8iso88p59p6 But When i tried on another computer and test database with AR8MSWIN1256 it's work just fine....
    Please anyone
     
  2. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,347
    Likes Received:
    348
    Trophy Points:
    1,430
    Location:
    Aurora, CO
    You can't change the characterset on export. You can export the data, drop the schema tables, change the database charcterset then import the data. Read here:

    http://download-uk.oracle.com/docs/cd/B14117_01/server.101/b10749/ch2charset.htm#i1007203
     
  3. itx005

    itx005 Active Member

    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    55
    thanks for your replay...
    But the link is not working!
     
  4. Sadik

    Sadik Community Moderator Forum Guru

    Messages:
    1,906
    Likes Received:
    252
    Trophy Points:
    1,455
    It's working for me.