Home » SQL & PL/SQL » SQL & PL/SQL » How to deal with multiple language SQL script
How to deal with multiple language SQL script [message #206119] Tue, 28 November 2006 19:10
Spark_Hong
Messages: 9
Registered: November 2006
Junior Member
Hi All,

We now want to create a SQL script that contains multiple languages(English, Chinese, Japanese), this script need to be run at there different database installed on different OS, for example, Oracle9i on Windows 2000 English Edition/Chinese Edition/Japanese Edition.

If I save the file as ANSI format, this file will only be recognized at local OS(e.g. the Chinese and Japanese character will not be normally displayed on other OS, if I run the script, the CH/JP characters will not be stored normally in DB).

If I save the file as Unicode format, this file can be recognized by all three OS, but Oracle SQL Plus will not recognize it, thus we can't run the script.

Who can tell me how to deal with this issue? Is it possible to save only one script that can run on different language OS?

Thanks,
Spark
Previous Topic: About Cursors
Next Topic: if you Please
Goto Forum:
  


Current Time: Fri Dec 02 14:04:34 CST 2016

Total time taken to generate the page: 0.07550 seconds