mysql and java application:characters not displaying right
Paul Cullen
Greenhorn
Joined: Sep 07, 2007
Posts: 11
posted
0
I have built a java (not jsp or servlet) using a database(character set to latin5) built in mysql with esclipse.When I query the database all the characters appear correct.But when the method below is called its meant to display the sample string (bh� m�) but displays as (bh� m�) inthe java front end. try { Class.forName( JDBC_DRIVER ); // load database driver class
// specify properties of JdbcRowSet JdbcRowSet rowSet = new JdbcRowSetImpl(); rowSet.setUrl( DATABASE_URL ); // set database URL rowSet.setCommand("SELECT positive FROM verbTable7 " + "WHERE word = '" + verbList.getSelectedItem ().toString()+ "'" +"AND tense = 'past'" ); // set query rowSet.execute(); // execute query
// process query results ResultSetMetaData metaData = rowSet.getMetaData(); int numberOfColumns = metaData.getColumnCount();