Your database connection dialect is not Unicode safe.

Question

I updated Qvera and I now recieve the following Alert when I login.

Your database connection dialect is not Unicode safe. For instructions, go to Help -> QIE Install Guide Search for "Configure QIE with an Alternate Database".

Answer 1

Qvera Interface Engine will save binary data to the database for some channels. In order for this to be saved correctly a Unicode Safe Dialect is required for the database qie is using.  Follow the steps below to update the dialect being used.

1. Open the QIE Service Manager
   
   
    
2. Click on the startup tab
   
   
    
3. In the arguments update the dialect line to one of the following based on the database you are connecting to and Apply the changes:
   • Microsoft SQL
     -Dhibernate.dialect=com.qvera.qie.persistence.SQLServer2008UnicodeDialect
   • MySQL
     -Dhibernate.dialect=com.qvera.qie.persistence.MySQLUnicodeDialect
   • MariaDB
     -Dhibernate.dialect=com.qvera.qie.persistence.MySQLUnicodeDialect
      
4. Click on the General Tab and Stop and Start the QIE service
   
   
   
   Note: It will take from 5-20 minutes longer to start the service due to time it takes to convert the fields in the database.