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

Avatar

Please consider registering
guest

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
Avatar
Hendrik Schmidt
Member
Forum Posts: 11
Member Since:
24 Feb 2017
sp_UserOfflineSmall Offline

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

01 Jun 2018
2:58 pm
Avatar
Knut
Member
Forum Posts: 218
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.
Knut

Forum Timezone: Europe/Amsterdam

Most Users Ever Online: 131

Currently Online:
25 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

ulrich-merkel: 1808

Iain Sharp: 659

Theo Neeskens: 362

gianni: 318

istiller: 275

rogerw: 266

Knut: 218

lalitpct: 197

Arjen van Vliet: 180

sochaz: 173

Member Stats:

Guest Posters: 3

Members: 9271

Moderators: 0

Admins: 8

Forum Stats:

Groups: 1

Forums: 62

Topics: 2246

Posts: 9703

Newest Members:

Artycor, GenaDax, ClaytonLak, Reginaaroms, PornosexSl, Vikarew, benyb2, MarvinSaire, Michaelsen, Gotovimprofile

Administrators: admin: 23, Adrian Gosbell: 318, diseli: 1001, Bob Maier: 3, Nico Peereboom: 77, Michael Rabone: 4, richiet: 406, JanCees: 34