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: 201
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: 179
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: 201
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: 264
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: Henk van der Veer
6 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

ulrich-merkel: 1710

Iain Sharp: 623

Theo Neeskens: 345

gianni: 264

rogerw: 232

istiller: 201

lalitpct: 197

Knut: 179

-GHAN-: 171

Arjen van Vliet: 170

Member Stats:

Guest Posters: 3

Members: 7038

Moderators: 0

Admins: 8

Forum Stats:

Groups: 1

Forums: 62

Topics: 2058

Posts: 8862

Newest Members:

Arabellaquife, ArthurEffit, RubenKip, MarinaGOVunse, Olpbtsj, Richardglums, Hellbladequife, RobertCab, Kcrdhlq, Kennethsherm

Administrators: admin: 23, Adrian Gosbell: 286, diseli: 836, Bob Maier: 3, Nico Peereboom: 65, Michael Rabone: 4, richiet: 406, JanCees: 28