Problem Description
Using CSSBackup, the process fails with the error below :
[XMLtoDB] SQL Error: ERROR: character 0xe28099 of encoding "UTF8" has no equivalent in "LATIN1" (Severity 1, Msg# 1).
The wrong character number can change.
The error is due to a UTF8 Character entered as a comment of a violation that was marked for 'Exclusion'.
Applicable in CAST Version
Release | Yes/No |
---|---|
8.3.x |
Action Plan
Remove using the query below the non ascii characters and replace it with a ?
update DSS_ENGINE_EXCEPTION set COMMENT = regexp_replace(COMMENT, '[^a-zA-Z0-9 \s\n\t\r.,:!_\-;/]', '?', 'g')
Notes / Comments
Related Pages