Convert database to UTF-8
What it does
Special characters causing errors
The default support for UTF8 is 3 byte.
Using 4 byte UTF content in text areas, can cause errors, that looks like
java.sql.SQLException: Incorrect string value: '\xC2\x96 Z. ...' for column 'NOTES' at row 1
How to invoke
Update the database to full UTF8 support using the following command
main?command=dk.p2e.blanket.codeunit.common.PageConvertDatabaseToUTF8
Note an administration profile is needed to complete the operation.
You might also have to update the tomcat server.xml file.
You have to add useBodyEncodingForURI="true"
to the connectors.
Options
[Optional options, that can be set at runtime, eg. url-parameters]
Configuration
[All possible configurations and where to edit them]
Developer info
- Type: CodeunitPagecontent
- Security: Requires administrator
- Classpath: dk.p2e.blanket.codeunit.common.PageConvertDatabaseToUTF8