Hi Rick, thank you for your reply. Sorry for not being clearer. The load is succeeding even without the derby.ui.codeset property being set. However, when selecting the data in ij afterwards, some of the special characters do not display as intended.
So there is some sort of encoding/conversion mismatch happening during import of the SQL file. Surely there is a way to avoid this so I'm trying to figure out what the correct encoding for the SQL file is to prevent such problems without having the specify the derby.ui.codeset property. Greetings/Thanks Robert -- View this message in context: http://apache-database.10148.n7.nabble.com/Executing-SQL-file-character-encoding-tp128380p128395.html Sent from the Apache Derby Users mailing list archive at Nabble.com.