How can i set encoding for Table and row using hibernate

Question

I am new in java Hibernate and i try to make simple Hello world project.

I make a UserClass:

@Entity
@Table(name = "Table_User")
public class Table_User extends BaseObject implements Serializable {

    private String name;

    public Table_User(){
       //default  constructor
    }


    public TableUser(String name){
      this.name=name;
    }

    public String getName(){ return this.name; }
    public void setName(String name){ this.name=name; }


}

I am generate table using <property name="hibernate.hbm2ddl.auto" value="update"/>.

My question is.

How can i SET encoding for table and row name?

I want set utf8_czech_ci but is latin1_swedish_ci.

Thank you for your reply!

EDIT, my persisence.xml file is:

    <persistence-unit name="org.my"  transaction-type="RESOURCE_LOCAL">
        <provider>org.hibernate.jpa.HibernatePersistenceProvider</provider>

        <properties>
            <property name="hibernate.hbm2ddl.auto" value="update"/>
            <property name="openjpa.jdbc.SynchronizeMappings" value="buildSchema"/>

            <property name="hibernate.connection.driver_class" value="com.mysql.jdbc.Driver"/>

            <property name="hibernate.connection.password" value=""/>
            <property name="hibernate.connection.username" value="root"/>
            <property name="hibernate.connection.url" value="jdbc:mysql://localhost:3306/myDb"/>

            <property name="hibernate.dialect" value="org.hibernate.dialect.MySQL5InnoDBDialect"/>
            <property name="hibernate.validator.apply_to_ddl" value="true" />

            <property name="connection.provider_class" value="org.hibernate.connection.C3P0ConnectionProvider"/>
            <property name="hibernate.c3p0.min_size" value="5"/>
            <property name="hibernate.c3p0.max_size" value="20"/>
            <property name="hibernate.c3p0.timeout" value="300"/>
            <property name="hibernate.c3p0.max_statements" value="50"/>
            <property name="hibernate.c3p0.idle_test_period" value="300"/>

        </properties>
    </persistence-unit>
</persistence>

Specify the "characterEncoding" to be "utf8" (or perhaps "UTF-8", check the Hibernate manual). — Rick James
– Rick James, Commented Dec 19, 2015 at 23:08

Vlad Mihalcea · Accepted Answer · 2015-12-19 10:48:59Z

1

The encoding is always set at database level, not in the Hibernate mapping. If you are using MySQL, you can set it as follows:

CREATE DATABASE mydb
  DEFAULT CHARACTER SET utf8
  DEFAULT COLLATE utf8_czech_ci;

answered Dec 19, 2015 at 10:48

Vlad Mihalcea

156k85 gold badges599 silver badges984 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How can i set encoding for Table and row using hibernate

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related