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: 251
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: 211
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: 251
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: 301
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:
18 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

ulrich-merkel: 1782

Iain Sharp: 653

Theo Neeskens: 353

gianni: 301

rogerw: 260

istiller: 251

Knut: 211

lalitpct: 197

Arjen van Vliet: 175

sochaz: 173

Member Stats:

Guest Posters: 3

Members: 8718

Moderators: 0

Admins: 8

Forum Stats:

Groups: 1

Forums: 62

Topics: 2192

Posts: 9481

Newest Members:

VikaDit, Refomibon, NapsdqaLews, BssaeqiLews, vasin159, NYAlex, Demodom, DorrisSek, HousepfReviews2, gahaddence

Administrators: admin: 23, Adrian Gosbell: 317, diseli: 958, Bob Maier: 3, Nico Peereboom: 77, Michael Rabone: 4, richiet: 406, JanCees: 28