UTF-8 and MS Access

[Sahil Sharma]

Hi

I am retrieving the data from MS Access database using stand alone java client. One of the columns in the table contains UTF-8 character (Japanese). When I fetch the data and print on the console it is not showing me the actual value, instead I am getting junk data with ???. I have also set the character encoding to UTF-8 as part of my connection string but still it is not working. What could be the possible reason for this?

Thanks.

[Lanny Gilbert]

Please show your code.

[Sahil Sharma]

import java.io.InputStreamReader;
import java.io.Reader;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.Properties;


public class Test {

	/**
	 * @param args
	 */
	public static void main(String[] args) {
		// TODO Auto-generated method stub
		
		try {
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
			Properties props = new Properties();
			props.put ("charSet", "UTF-8");
			Connection connect = DriverManager.getConnection("jdbc:odbc:testDS",props);
			Statement st = connect.createStatement();
			
			String query = "select firstname from temp";
			
			ResultSet rs = st.executeQuery(query);
			
			 int read = 0;
			Reader reader = null;
			
			char[] buffer = new char[1024];
			StringBuffer result = new StringBuffer();

			

			

			while(rs.next()){
			
				System.out.println(rs.getString("firstname"));
				reader = new InputStreamReader(rs.getBinaryStream("firstname"), "UTF-8");
				while((read = reader.read(buffer)) != -1) 
	               {
	                    result.append(buffer, 0, read);
	                }
				
				System.out.println(result);
			}
			
			
		
			rs.close();
			
			
		} catch (Exception e) {
			// TODO: handle exception
		}
		System.out.println("english letters. русские буквы");
	}

}

When I sysout the value. It is coming as ???. I am using eclipse as an IDE and have the character encoding there as well to UTF-8 and still it is not working.

[Rob Spoor]

The console, to which System.out prints (and System.err as well), cannot handle Unicode characters, or almost anything that isn't ASCII. It's not a Java limitation.