[hibernate-issues] [Hibernate-JIRA] Created: (HHH-3443) Cannot get UTF-8 Strings from MySQL DB

[Chris Welz (JIRA)]

Cannot get UTF-8 Strings from MySQL DB
--------------------------------------

                 Key: HHH-3443
                 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-3443
             Project: Hibernate3
          Issue Type: Bug
    Affects Versions: 3.2.6
         Environment: MySQL 5, JRE 1.6
            Reporter: Chris Welz


Hi,

I've tried now for 2 days to get my Hibernate Application reading UTF-8 Strings from the Database with no success.

I created my Database with the following SQL Script:
CREATE TABLE IF NOT EXISTS `t_gvz_type_name` (
  `ID_GVZ_Type_Name_intern` int(11) NOT NULL,
  `Type_GVZ` int(11) default NULL COMMENT 'Typ der Gebietskörperschaft',
  `Name_GVZ_Type` varchar(50) default NULL COMMENT 'Name des Types der Gebietskörperschaft',
  `LanguageID` int(11) default NULL,
  PRIMARY KEY  (`ID_GVZ_Type_Name_intern`),
  KEY `FK_GVZ_Type_Name_Language` (`LanguageID`),
  KEY `FK_GVZ_Type_Name` (`Type_GVZ`)
) ENGINE=InnoDB DEFAULT CHARACTER SET utf8 COMMENT='Name des Gebietskörperschaftstypes';


My hibernate.cfg.xml:
 <property name="hibernate.bytecode.use_reflection_optimizer">false</property>
        <property name="hibernate.connection.driver_class">org.gjt.mm.mysql.Driver</property>
        <property name="hibernate.connection.password">christian</property>
        <property name="hibernate.connection.url">jdbc:mysql://localhost:3306/vzf_net?useUnicode=true&amp;characterEncoding=utf8</property>
        <property name="hibernate.connection.username">root</property>
        <property name="hibernate.current_session_context_class">org.hibernate.context.ThreadLocalSessionContext</property>
        <property name="hibernate.dialect">org.hibernate.dialect.MySQL5InnoDBDialect</property>

This is, how I try to get the values from DB:
List result = session.createQuery("from TGvzTypeName where TGzvType="+TypeGvz).list();


What do I have to do to get the Strings in UTF-8 ?
 

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira