Error 0131 ..characterset not supported/allowed for Unicode chharacters | Uniface 9 | Forum


Please consider registering

sp_LogInOut Log In sp_Registration Register

Register | Lost password?
Advanced Search

—  Results per page  —

— Match —

— Forum Options —

Minimum search word length is 3 characters - maximum search word length is 84 characters
For a group of consecutive words like 'end of support' use Match phrase

sp_Feed Topic RSS sp_TopicIcon
Error 0131 ..characterset not supported/allowed for Unicode chharacters
01 Jun 2018
10:55 am
Hendrik Schmidt
Forum Posts: 12
Member Since:
24 Feb 2017
sp_UserOfflineSmall Offline


we have Uniface and Oracle DB

we migrated the database characterset from WE8ISO8859P15 to AL32UTF8 using Oracles DMU ( Database Migration Assitant for Unicode).

We set in the ASN’s




we changed in the repository the character field Definition from Cxxx or C* to Wxxxx or W* or U*  and MUL to FUL


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


01 Jun 2018
2:58 pm
Forum Posts: 224
Member Since:
01 Oct 2012
sp_UserOfflineSmall Offline

Hi Hendrik,

If everything being equal (same server, same Uniface Executable etc) – the difference would more than
likely be on the PC itself – Oracle client would be my 1st guess, then language packs available / installed
on the two different systems….

Turn on debug before you open the Oracle database, and you’ll get version information about the client
and the server…

Hope this helps.

Forum Timezone: Europe/Amsterdam

Most Users Ever Online: 131

Currently Online:
32 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

ulrich-merkel: 1868

Iain Sharp: 674

Theo Neeskens: 366

gianni: 341

Adrian Gosbell: 318

istiller: 295

rogerw: 270

Knut: 224

lalitpct: 197

Arjen van Vliet: 184

Member Stats:

Guest Posters: 3

Members: 10299

Moderators: 0

Admins: 6

Forum Stats:

Groups: 1

Forums: 62

Topics: 2290

Posts: 9937

Newest Members:

Ridgesn, SaphbamE, NanarrjLews, bruceus18, LesleyCag, rebeccavy1, jackieps69, GalenIcew, Gessonv, Tommycoado

Administrators: admin: 23, diseli: 1024, Nico Peereboom: 84, richiet: 406, Mike Taylor: 35, JanCees: 38