Changeover from CP1252 to Unicode: Experince?

Author: i2stiller@gmx.de (istiller)

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

3 Comments

  1. 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


    Author: Knut (knut.dybendahl@gmail.com)
  2. 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 :-)


    Author: istiller (i2stiller@gmx.de)
  3. 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


    Author: gianni (gianni.sandigliano@unifacesolutions.com)