Changeover from CP1252 to Unicode: Experince? | 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
Changeover from CP1252 to Unicode: Experince?
22 Aug 2017
10:25 am
Avatar
istiller
Member
Forum Posts: 221
Member Since:
01 Oct 2012
sp_UserOfflineSmall Offline

Hi freaks

Our applictaion (from 1990) still runs CP1252, but now it’s time to use unicode 🙂
No problem at all in UnifAce, just change all “C” to “W” and compile all components.
But wait, what about the strings in database, we have to convert them too.
Okay, export data to XML, alter the database, switch over to new defintions (new components,URR,…) an load the data.
So far so good.

But our customers do have databases up to 150 GB data.
How to handel this amount of data in a proper way?

Any experinces out there, how long it take to convert n GB of data by Uniface?
Or is it possible to convert CP1252 to unicode by SQL itself?

TIA
Ingo

22 Aug 2017
8:25 pm
Avatar
Knut
Member
Forum Posts: 189
Member Since:
01 Oct 2012
sp_UserOfflineSmall Offline

Ingo,

What’s the dbms in question?

If it’s Oracle, you should be able to export the data using the Oracle export utility.
Then, create the new schema with the UTF-8 definitions. Follow up with using
the Oracle import facilty which takes the data from the previous export, and
converts to the format / code page of the new schema…. or so I am led to believe
(from the Oracle documentation itself).

Regards,
Knut

02 Oct 2017
10:01 am
Avatar
istiller
Member
Forum Posts: 221
Member Since:
01 Oct 2012
sp_UserOfflineSmall Offline

Knut said
Ingo,

What’s the dbms in question?

Regards,
Knut  

Oracle, what’s that?
Every “normal” customer will use MS-SQL *)

Ingo

*) Adjust your ironie detector before you answer 🙂

02 Oct 2017
12:59 pm
Avatar
gianni
Member
Forum Posts: 276
Member Since:
01 Oct 2012
sp_UserOfflineSmall Offline

istiller said

Knut said
Ingo,

What’s the dbms in question?

Regards,
Knut  

Oracle, what’s that?
Every “normal” customer will use MS-SQL *)

Ingo

*) Adjust your ironie detector before you answer 🙂  

Hi guys,

Last week a potential customer told me:
DB2, Oracle, MS-SQL? Time to move on…
Every “up2date” customer is already moving to PostgreSQL!

Gianni

Forum Timezone: Europe/Amsterdam

Most Users Ever Online: 131

Currently Online: schut
16 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

ulrich-merkel: 1731

Iain Sharp: 637

Theo Neeskens: 349

gianni: 276

rogerw: 244

istiller: 221

lalitpct: 197

Knut: 189

Arjen van Vliet: 174

sochaz: 173

Member Stats:

Guest Posters: 3

Members: 7663

Moderators: 0

Admins: 8

Forum Stats:

Groups: 1

Forums: 62

Topics: 2103

Posts: 9102

Newest Members:

JerryJax, WilliamEmoth, StacyEcola, Williamnum, erinna60, DavidAnine, plaza, ErmaveBob, TanaKes, dxzoom

Administrators: admin: 23, Adrian Gosbell: 291, diseli: 882, Bob Maier: 3, Nico Peereboom: 72, Michael Rabone: 4, richiet: 406, JanCees: 28