This is a quik guide for you to change the codeset and territory of your db2 database
- Start->Run
- db2cmd
- >db2move db_name export
- >db2look -d db_name -e -a -x -o db_name.sql
- >db2 drop db db_name
- >create db db_name using codeset iso8859-1 territory cn
- >db2 -tvf db_name.sql
- >db2move db_name load
- >db2 set integrity for table_name immediate checked
转载于:https://blog.51cto.com/yzx2107/28509