Hallo,

were are using import.sql to load some seed data after initial database creation by setting hibernate.hbm2ddl.auto=create.
The problem is, that some special German characters (üäöß-Umlauts) are not inserted correctly into mysql database. Using a database tool they are shown as cryptic characters.

I cannot find some detailed information about the usage of import.sql. Is there a more detail documentation somewhere?
Is it necessary to set a character encoding somewhere in persistence.xml, import.sql or elsewhere?

Environnment:
JBoss 5.0.1 (Windows)
EJB 3.0
hibernate-core specVersion 3.3.1.GA
hibernate-entitymanager specVersion 1.0
mysql-connector-java-5.0.8.jar
MySql 5.0.51 (Windows and Linux)
Eclipse 3.4.2

Thanks for your help
Viktor