How to insert non-English into Oracle DB?

[volcano]

hello, I have written a simple Java application which will insert Chinese into my Oracle table. However when I retrieve the data, I just see unreadable words. Do you think what I should modify my program so that I can acheive my objective? Thanks for your help!

-------------- Sample Code -----------------------
public class TEST {
public static void main(String[] args) throws Exception{
String cs = "XXXXXXXXX"; // some Chinese here

try {
Class.forName("oracle.jdbc.driver.OracleDriver&quot.newInstance();
DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
System.out.println("Driver found..."
Connection conn = DriverManager.getConnection("jdbcracle:thinXXX:XXX
:XXX", "XXX", "XXX"

Statement sql = conn.createStatement();
sql.execute("insert into greeting (content) values ('" + cs + "')"
}
catch (Exception e) {
System.out.println("Insert DB error:" + e);
}
}
}

 

[maxpower1]

you have to setup the language properly in Oracle database, as far as I know. Since the default language is English, some parameters have to be set to enable this feature.

Then, write some test pl/sql codes and try to insert some chinese chars using unicode. If you're able to do it from here, then there should not be any problems passing the unicode from the web/java screens to your middle tier -> db.

~za~
You can't bring back a dead thread!

 

[jwenting]

yes, you have to enable Oracle for UTF-8 support.
Either that or use a BLOB field to store the data, which is slow and cumbersome.