Mixture of utf-8 languages becomes ?.... or ''

[glloyd1]

I am trying to store a mixture of languages in a single table as utf-8 text, all of which becomes either ??... or in the case of french an empty string. I am using the connector/j driver.

This is my code that opens the connection:
String url = "jdbc:mysql://setdevdb1.setimes.com:3306/MetaDataDB?useUnicode=true&characterEncoding=UTF8";
Class.forName("com.mysql.jdbc.Driver");
Connection con =DriverManager.getConnection(url,"dba","setimes");
Statement st= con.createStatement();
st.execute("SET NAMES 'utf8'");
st.close();
st= con.createStatement();
ResultSet r= st.executeQuery("SHOW VARIABLES LIKE 'CHAR%'");
while(r.next())
{
System.out.println("Variable:"+ r.getString("Variable_name")+" Value:"+ r.getString("Value"));
}
r.close();
st.close();
return con;


SHOW VERSION() returns:
4.1.8-standard-log


SHOW VARIABLES LIKE 'CHAR%' returns the following:

Variable:character_set_client Value:utf8
Variable:character_set_connection Value:utf8
Variable:character_set_database Value:utf8
Variable:character_set_results Value:utf8
Variable:character_set_server Value:latin1
Variable:character_set_system Value:utf8
Variable:character_sets_dir Value:/usr/share/mysql/charsets/

SHOW CREATE TABLE MetaData returns:

CREATE TABLE `MetaData` (
`KEY` int(11) NOT NULL auto_increment,
`ID` varchar(255) NOT NULL default '',
`TITLE` varchar(255) NOT NULL default '',
`LANG` varchar(10) NOT NULL default 'en_GB',
`DATE` date NOT NULL default '0000-00-00',
`IMAGE` varchar(255) default NULL,
`TEASER` varchar(255) default NULL,
`SITE` varchar(10) NOT NULL default 'mewi',
PRIMARY KEY (`KEY`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8


Can somebody tell me what is wrong with this picture?



Edited 1 time(s). Last edit at 06/21/2005 09:02AM by glloyd1.