Understanding Converting to Unicode on Microsoft SQL Server and DB2 Databases

On Microsoft SQL Server and DB2 databases, PeopleSoft supports converting a PeopleSoft database to Unicode by re-creating the database using Data Mover to import database contents. With Microsoft SQL Server databases, for the best performance, run Data Mover on the same machine as the database server.

PeopleSoft requires that an entire database be created as a Unicode database or as a non-Unicode database – mixing CHAR and NVARCHAR columns in a single PeopleSoft database is not supported.