Code Page changing.

new_user1 · #1 (**permalink**) 04-13-04, 20:45

Hello List,

I have a question regarding codepage setting for DB2. Is there a way to change the Code set of an existing Db2 database?

We have to change the codepage from "IBM-1252" to "UTF-8" of existing DB2 database and i was wondering, If this is possible??

Please advice.

Thanks for all your help.

dollar489 · #2 (**permalink**) 04-13-04, 21:21

Nope, you have to do it hard way. Drop and recreate the database with correct code page. Make sure to extract database structure using db2look and export data out if you required.

dollar

Quote:

Originally posted by new_user1
Hello List,

I have a question regarding codepage setting for DB2. Is there a way to change the Code set of an existing Db2 database?

We have to change the codepage from "IBM-1252" to "UTF-8" of existing DB2 database and i was wondering, If this is possible??

Please advice.

Thanks for all your help.

Internet Services

Web Development

Digital Marketing

Consumer Tech