Exact Financials

Technical manuals Exact Financials - Database migration 7.x to 7.27 SQL (Change codepage to UTF-8)

Exact Financials UTF-8 Migration manual

When Exact Financials is updated to 7.25 you also need to change the codepage of your databases. In this manual the databases are named 'exactcs' and 'edis'.
After installing an upgrade you normally start the AppServer. However when updating from a version equal to or lower than 7.24 the Appserver will refuse to start. In the AppServer server log you will find a message like: 'Database 'exactcs' has codepage 'ISO8859-1', it should be 'UTF-8' - quitting to prevent data corruption.'

To resolve this you need to change the codepage of the database from ISO8859-1 to UTF-8. This manual will explain how to achieve this for Progress OpenEdge Database. The codepage should be changed before the regular conversionscripts are run.

Microsoft SQL Server:

1. Make sure there a full backup of the database has been made.
2. Start your SQL Server Management Studio and connect to your database engine.
3. Open a new query window for your exactcs database.
4. Execute the SQL script "\\<Install directory Exact Financials>\cd\db\mss\exactcs725-725.collation.sql" to change to collation to "Latin1_General_100_CI_AI".
5. Open a new query window for your edis database.
6. Execute the SQL script "\\<Install directory Exact Financials>\cd\db\mss\edis725-725.collation.sql" to change to collation to "Latin1_General_100_CI_AI".
7. You can now execute the required update scripts from "\\<Install directory Exact Financials>\cd\db\mss" or let the system handle this by starting the Appserver, WebSpeed, PASOE or Scheduler.