Error 0131 ..characterset not supported/allowed for Unicode chharacters
Author: hschmidt@versorgungskammer.de (Hendrik Schmidt)
Hello, we have Uniface 9.7.0.4.x and Oracle DB 12.1.0.2. we migrated the database characterset from WE8ISO8859P15 to AL32UTF8 using Oracles DMU ( Database Migration Assitant for Unicode). We set in the ASN's $DEF_CHARSET = utf8 $SYS_CHARSET = utf8 $WIDE_CHAR_BEHAVIOR = Unicode we changed in the repository the character field Definition from Cxxx or C* to Wxxxx or W* or U* and MUL to FUL eg: update fare.ucfield set u_intf = replace(u_intf, 'C', 'W') where u_vlab = 'MR' and u_dtyp = 'S' and u_intf like 'C%' and u_flab <> 'U_VERSION'; update fare.ucfield set u_syn = replace(u_syn, 'MUL', 'FUL') where u_vlab = 'MR' and u_syn like '%MUL%'; commit; -> 1661 Zeilen aktualisiert. update fare.uxfield set INTERFACEMOD = replace(INTERFACEMOD, 'C', 'W') where ubase = 'MR' and INTERFACEMOD like 'C%'; -> 5916 Zeilen aktualisiert. update fare.uxfield set SYNTAXMOD = replace(SYNTAXMOD, 'MUL', 'FUL') where ubase = 'MR' and SYNTAXMOD like '%MUL%'; -> 3486 Zeilen aktualisiert. We recompiled whole Application On one System we can now insert/save/query Unicode characters eg: าธาต but in a 2nd System we still receive the Error 0131 ..characterset not supported/allowed for Unicode chharacters At this Moment, we ran a Little bit out of ideas, what can be wrong or different between both Systems. Any ideas? many thanks in advanced Hendrik
