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!

Add china font in oracle db 10g

Discussion in 'Oracle Forms and Reports' started by Rafat_nasar2010, Jun 8, 2019.

  1. Rafat_nasar2010

    Rafat_nasar2010 Starter

    Messages:
    7
    Likes Received:
    0
    Trophy Points:
    10
    Location:
    Egypt
    Please how i add china font in oracle db 10 g by oracle dev 6i

    I want to type china chars in text box in form by dev 6i
     
  2. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,682
    Likes Received:
    376
    Trophy Points:
    1,430
    Location:
    Aurora, CO
  3. Rafat_nasar2010

    Rafat_nasar2010 Starter

    Messages:
    7
    Likes Received:
    0
    Trophy Points:
    10
    Location:
    Egypt
    Thank you for your support
     
  4. Rafat_nasar2010

    Rafat_nasar2010 Starter

    Messages:
    7
    Likes Received:
    0
    Trophy Points:
    10
    Location:
    Egypt
    I change Character set to AL32UTF8 but china characters appear as ?????

    Please help
     
  5. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,682
    Likes Received:
    376
    Trophy Points:
    1,430
    Location:
    Aurora, CO
    Simply changing the character set does NOT migrate existing data. Everything inserted or updated before the character set change does not get migrated. That data will need to be updated or inserted again.

    Inserting multi-byte characters into a single-byte character set converts those characters into values that won't render the original characters -- most multi-byte characters become '?' and can't be reversed. UTF-8 needed to be installed BEFORE entering any Chinese characters.

    You now have maintenance to perform to get these characters inserted properly.
     
  6. Rafat_nasar2010

    Rafat_nasar2010 Starter

    Messages:
    7
    Likes Received:
    0
    Trophy Points:
    10
    Location:
    Egypt
    Thank you for your kindly support, but when i insert or update new records its appear as ????
    Please need your help
     
  7. Rafat_nasar2010

    Rafat_nasar2010 Starter

    Messages:
    7
    Likes Received:
    0
    Trophy Points:
    10
    Location:
    Egypt
  8. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,682
    Likes Received:
    376
    Trophy Points:
    1,430
    Location:
    Aurora, CO
    You update those records with the correct Chinese characters --

    update blah
    set yammel = 'some Chinese characters'
    where blord = <some value>;

    considering that blah is the table name, blord is the record key and yammel is the column. that is affected. If you cannot perform updates then it may be necessary to delete the affected records and insert them again, if you have the data available. This is where scripts and CSV files are good to have. If your job is managing this data then it is absolutely necessary for you to be able to restore and recover that data.
     
  9. Rafat_nasar2010

    Rafat_nasar2010 Starter

    Messages:
    7
    Likes Received:
    0
    Trophy Points:
    10
    Location:
    Egypt
    I send to you toad and form builder 6i pictures, I want to insert Chinese characters via a form developed by Oracle Forms 6i

    Please help
     
  10. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,682
    Likes Received:
    376
    Trophy Points:
    1,430
    Location:
    Aurora, CO
  11. Rafat_nasar2010

    Rafat_nasar2010 Starter

    Messages:
    7
    Likes Received:
    0
    Trophy Points:
    10
    Location:
    Egypt
    Thank you for your kind support ,Finally Issue solved