Difference between revisions of "Full UTF8 support"
Jump to navigation
Jump to search
old>Admin |
m (2 revisions imported) |
(No difference)
|
Revision as of 11:52, 10 December 2021
Special characters causing errors
Problem
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
Solution
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.