package testsuite.simple;

import testsuite.BaseTestCase;

public class TestBug27867 extends BaseTestCase {

	public TestBug27867(String name) {
		super(name);
		// TODO Auto-generated constructor stub
	}
	public void testBug27867() throws Exception {
	    	try {
	    		System.out.println("java.vm.version         : " + System.getProperty("java.vm.version"));
	    		System.out.println("java.vm.vendor          : " + System.getProperty("java.vm.vendor"));
	    		System.out.println("java.runtime.version    : " + System.getProperty("java.runtime.version"));
	    		System.out.println("os.name                 : " + System.getProperty("os.name"));
	    		System.out.println("os.version              : " + System.getProperty("os.version "));
	    		System.out.println("sun.management.compiler : " + System.getProperty("sun.management.compiler"));

	    		createTable("ColumnNameEncoding", "("+
	        		    "`中文测试` varchar(1) default NULL,"+
	        		    "`ASCIIColumn` varchar(1) default NULL"+
	       			")ENGINE=MyISAM DEFAULT CHARSET=utf8");
	    		this.rs = this.stmt.executeQuery("SELECT * FROM ColumnNameEncoding");
	    		java.sql.ResultSetMetaData tblMD = this.rs.getMetaData();
	    		this.rs.first();
	    		for (int i=1; i<tblMD.getColumnCount()+1; i++)
	    		{	
	      		  System.out.println(i + " .fld: " + tblMD.getColumnName(i));	    		
	    		}
	    	}
	    	finally {
	    		closeMemberJDBCResources();
		}
	}

	/**
	 * @param args
	 */
	public static void main(String[] args) {
		// TODO Auto-generated method stub
        junit.textui.TestRunner.run(TestBug27867.class);
	}

}