Sidebar

Your database connection dialect is not Unicode safe.

0 votes
504 views
asked Nov 7, 2014 by brandon-w-8204 (33,330 points)
edited Nov 17, 2014 by gary-t-8719

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".

1 Answer

+2 votes
 
Best answer

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.
answered Nov 7, 2014 by brandon-w-8204 (33,330 points)
selected Nov 8, 2014 by brandon-w-8204
...