Difference between revisions of "Full UTF8 support"

From TempusServa wiki
Jump to navigation Jump to search
old>Admin
(Created page with " == Special characters causing errors == === Problem === The default support for UTF8 is 3 byte. Using 4 byte UTF can cause errors, that looks like java.sql.SQLExceptio...")
 
old>Admin
Line 5: Line 5:
The default support for UTF8 is 3 byte.
The default support for UTF8 is 3 byte.


Using 4 byte UTF can cause errors, that looks like  
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
   java.sql.SQLException: Incorrect string value: '\xC2\x96 Z. ...' for column 'NOTES' at row 1

Revision as of 12:02, 21 May 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.