Collation speficfication at column level

Alberthoven · **Joined:** Tue Feb 17, 2009 5:13 am **Posts:** 59

Hi all.

I need to set an specific collation type for DB, so I have overwritten MySQL5InnoDBDialect class.

Code:

import org.hibernate.dialect.MySQL5InnoDBDialect;

public class CustomMysqlDialect extends MySQL5InnoDBDialect {

   public String getTableTypeString() {
        return "ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci";
    }
}

But I need a lower level specification due to I have to specify another collation for id columns... Concretely utf8_bin instead of utf8_spanish_ci.

Only for one column in each table. ¿How could I do that? ¿any idea?

Thanks in advance.

sanne.grinovero · **Posted:** Fri Jul 31, 2009 4:03 pm

@Column annotation?

If you need to set it "globally" like at the dialect level then you might have better chances in the hibernate core forums.

Alberthoven · **Joined:** Tue Feb 17, 2009 5:13 am **Posts:** 59

Ok, I have annotated my field with @Column(name = "uuid", columnDefinition = "varchar(23) COLLATE utf8_bin")

Remaining fields use the dialect specification.