Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Get Greek Data From Oracle DB

 
sankar singh
Ranch Hand
Posts: 40
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
i am trying to retrive data(GREEK LANGUAGE) from Oracle DB.
But character conversion happening, i mean its not displaying proper value. My pice of code here. i have done regional settings in Control Panel as Greek Language.


java.util.Locale.setDefault(new Locale("gr"));
Connection conn = null;
try {
DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
conn =DriverManager.getConnection ("jdbc racle:thin:@10.0.60.15:1521:FCCPP","userid","pwd");Statement stmt=conn.createStatement();
ResultSet rs=stmt.executeQuery("select * from greek_table where field_no=14");
if (rs.next())
System.out.println(" Address 1 "+ rs.getString((2)));
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}


Can you pls help to resolve this?. Its urgent. Thanks in Advance.

Regards,
Sankar. S
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic