How to migrate to UTF-8 databases?? - Forum - OpenEdge Deployment - Progress Community

How to migrate to UTF-8 databases??

 Forum

How to migrate to UTF-8 databases??

  • We are in the final stage of migration Progress8.3

    to v9.1.We have Chinese Japaneese and French

    versions of our application.In V 8.3 we use

    differenr(Chinese, Japanese..)code page versions

    of our database for each client. Now we create

    UTF-8 codepage version of our database(we dump it

    and then load into empty Utf-8 database).We are

    going to recompile our application using UTF-8

    database.What else should be done? What code

    page should be set in client,local or UTF-8?. Our

    application use 2 databases-the first we distributed and the second,local,created in the client. If we build .PL library using UTF-8 database,is it possible for application to use two

    different databases-UTF-8 codepage andsecond with local codepage?. Where can we get more information about using UTF-8 database?

    Thanks in advance to allwho can help!!

    Inna.

  • Inna,

    To upgrade a Progress database to Unicode you may use:

    1) Method 1:

    Copy Empty Unicode DB from: DLC/prolang/utf/empty

    Dump and Load

    Compile and map the word break table to DB

    proutil -C wbreak-compiler differenr(Chinese, Japanese..)code page versions

    of our database for each client. Now we create

    >UTF-8 codepage version of our database(we dump it

    and then load into empty Utf-8 database).We are

    >going to recompile our application using UTF-8

    database.What else should be done? What code

    >page should be set in client,local or UTF-8?. Our

    application use 2 databases-the first we distributed>and the second,local,created in the client. If we build

    >.PL library using UTF-8 database,is it possible for application

    >to use two> different databases-UTF-8 codepage andsecond with local

    >codepage?. Where can we get more information about using

    >UTF-8 database?>Thanks in advance to allwho can help!!

    >Inna.