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: 199
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: 175
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: 199
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: 257
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:
15 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

ulrich-merkel: 1694

Iain Sharp: 612

Theo Neeskens: 339

gianni: 257

rogerw: 232

istiller: 199

lalitpct: 197

Knut: 175

-GHAN-: 171

sochaz: 165

Member Stats:

Guest Posters: 3

Members: 6285

Moderators: 0

Admins: 8

Forum Stats:

Groups: 1

Forums: 62

Topics: 2032

Posts: 8749

Newest Members:

adbotter, KennethHub, MathewBew, Sarma, RichardSmare, Frostseekerquife, Lookeephi, Llberyquife, BrunoTop, Sirbop

Administrators: admin: 23, Adrian Gosbell: 278, diseli: 820, Bob Maier: 3, Nico Peereboom: 62, Michael Rabone: 4, richiet: 406, JanCees: 28