I'm using JBoss 4.2.2, MySQL 5.0

I'm deploying application with import.sql file which is supposed to be executed by hibernate and populate database with data

Problem is import.sql contains data in UTF encoding. And these data is inserted incorrectly. all non-ASCII characters are broken. MySQL database is set up with default UTF8 encoding and collation. I can insert utf data directly and I see it correctly, but data inserted from import.sql is broken.

Is it a bug?

Yes I tried to launch JBoss with -Dfile.encoding=UTF-8 - same result

ok
I found the solution.

I had to start JBoss with -Dfile.encoding=Shift_JIS JVM parameter

is it possible to tell hibernate wht encoding is used in import.sql?
I do not whant to add -Dfile.encoding=UTF8 or -Dfile.encoding=Shift_JIS to the JBoss launching parameters

hi,
sorry for my english. I'm studing how to create export/import data with hibernate.
can you explain me how you did it?
I have the same problema, but i need to create the class to read import.sql.

For export data, do you hava an idea?

thanks gianluca

create an import.sql file with SQL queries and put it into CLASSPATH