Change codeset to UTF-8

hooche · #1 (**permalink**) 12-06-04, 03:01

Is it possible to change codeset of a database.
How to save data? May be backup and restore into new codeset.
But i didn't find any 'codeset' word in restore database syntax.

Any ideas?

ARWinner · #2 (**permalink**) 12-06-04, 08:42

I do not think you can change the codeset of a database, even creating a new DB from a backup image. The only way you can do this is to create a new DB with the codeset you want. Then you will have to copy the data into it manually (db2move).

HTH

Andy

hooche · #3 (**permalink**) 12-06-04, 09:40

Thanks for your advice

Internet Services

Web Development

Digital Marketing

Consumer Tech