DB2 Backup coding page conversion

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Proxo
    #1

    DB2 Backup coding page conversion

    Hi,

    I have a database backup with coding cp1252 and I want to convert it
    into utf-8.
    How can I do that ?

    Best regards,
    Peter

    Tags: None
    • Ian
      #2
      Re: DB2 Backup coding page conversion

      Proxo wrote:
      Hi,
      >
      I have a database backup with coding cp1252 and I want to convert it
      into utf-8.
      How can I do that ?
      You can't change the database codepage via a restore operation.

      So, you have to restore the database in CP1252, export all DDL & data,
      drop/create database as UTF-8, and load data back again..

        Comment

        Previous template Next
        Working...