Default collation of H2

1,457 views

Skip to first unread message

Rabatjes

unread,

Jan 12, 2009, 8:55:42 PM1/12/09

to H2 Database

Hi,

does anyone know if the default collation of H2 is utf8_general_ci?

If not, how can I set it?
Executing set collation utf8_general_ci leads to the error:
Syntax error in SQL statement SET COLLATION UTF8_GENERAL_CI ; SQL
statement:

Thanks for any help,
Bart

Thomas Mueller

unread,

Jan 15, 2009, 1:59:51 PM1/15/09

to h2-da...@googlegroups.com

Hi,

> does anyone know if the default collation of H2 is utf8_general_ci?

H2 doesn't use a collation by default. For more information how to set
the collation, see
http://www.h2database.com/html/grammar.html#setcollation