User Profile

Collapse

Profile Sidebar

Collapse
magid
magid
Last Activity: Mar 28 '11, 05:03 AM
Joined: Mar 2 '11
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • magid
    replied to How to convert data with different charsets into other databases?
    in Oracle
    it doesn't work correctly

    select convert(menu_na me,'US7ASCII',' WE8ISO8859P1'),
    convert(menu_na me,'ar8mswin125 6','WE8ISO8859P 1'),
    convert((conver t(menu_name,'US 7ASCII','WE8ISO 8859P1')),'ar8m swin1256','WE8I SO8859P1'),
    menu_name
    from T$R_MENU@"TO201 .US.ORACLE.COM"
    WHERE MENU_ID=601011;

    result is
    EU?iY ?C?ICa? OCOaI?...
    See more | Go to post

      Leave a comment:

    • magid
      started a topic How to convert data with different charsets into other databases?
      in Oracle

      How to convert data with different charsets into other databases?

      hi
      we want to use database link to connect a Database for operating the select,update or ... commands,our destination database is WE8ISO8859P1 and current database is AR8MSWIN1256 cahrset, but when we operate a command to view data,all NonEnglish characters appear odd wich we can not recognize the appeared text, also if we use convert function no change would make, please help us to view right charachters with our database link.
      ...
      See more | Go to post
      No activity results to display
      Show More
      Working...