oracle - How to convert data with different charsets into other databases? -


Hello, we use database, database selection, update, or ... command, to operate our destination database Want WE8ISO8859P1 and the current database AR8MSWIN1256 is called, but when we run a command to see the data, all non-English characters appear weird, which we can not recognize the text that we see, even if we convert Do not make any changes to the function, please correct us Help to see the chromatograph with our database link

does not work with Convert Function

Convert (menu_name, 'US 7 SCII', 'V8 IO8859P 1 '), convert (menu_name,' r8 msuen 1256 ',' WE8ISO8859P1 '), convert ((MENU_ID = 601011; ) from "TO201.US.ORACLE.COM" to T7 R_MENU @ (menu_name , 'US7ASCII', 'WE8ISO8859P 1')), 'AR8mswin1256', 'WE8ISO8859P1' p> The result is the European Union? IE? C? ICA? OCOaI? E ? C? IC ?? ? C ?? Me? EU? IE? C? ICA? OCOaI? E ? C? IC ?? When you ask Oracle Database, do not you? C ?? I

Function is required to convert data from one character to another: it did it automatically The customer requesting the data will set the stars in the character that uses it.

In your case, you are missing non-English letters because they do not exist in WE8ISO8859P1!

You can use NVARCHAR2 instead of VARCHAR2 in your destination database to support Unicode characters. NVARCHAR2 is specially designed to handle such strings without modifying the database character set. Look for differences between VARCHAR2 and NVARCHAR2.

Comments