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.