import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;

public class Test {
	public static void main(String[] args) throws Throwable {
		String driver = "com.mysql.jdbc.Driver";
		String url = "jdbc:mysql://localhost/bambarbia?user=root&password=mysql";

		Class.forName(driver).newInstance();
		Connection conn = DriverManager.getConnection(url);

		// DDL: create table test (id INT AUTO_INCREMENT PRIMARY KEY, text LONGTEXT);
		
		conn.createStatement().execute("DELETE FROM test");

		PreparedStatement ps = conn
				.prepareStatement("INSERT INTO test (text) VALUES (?)");

		byte[] bytes = new byte[256];
		for (int i = 0; i < 256; i++) {
			bytes[i] = (byte) i;
		}

		ps.setString(1, new String(bytes, "windows-1252"));
		ps.execute();

		ps.setString(1, new String(bytes, "ISO-8859-1"));
		ps.execute();

		ResultSet rs = conn.createStatement().executeQuery(
				"SELECT text FROM test");

		while (!rs.isLast()) {
			rs.next();
			System.out.println(rs.getString(1));
		}

		ps.close();
		rs.close();
		conn.close();
	}
}