Working With Additional Microsoft SQL Server 2005 Data Type Mappings

If your site has upgraded to a PeopleSoft 9.x application and performed the appropriate conversion process during the application upgrade, different data type mappings exist between PeopleSoft field types and the underlying Microsoft SQL Server 2005 system.

See The upgrade documentation and release notes for your release for information about the conversion process.

The following table describes how the PeopleSoft field types map to the underlying Microsoft SQL Server data types:

PeopleSoft Field Type	Pre-Conversion Microsoft SQL Server Data Type Mapping	Post-Conversion Microsoft SQL Server Data Type Mapping
Character	ANSI: CHAR Unicode: NCHAR	ANSI: VARCHAR(n) Unicode: NVARCHAR(n)
Long Character	ANSI: TEXT Unicode: NTEXT	ANSI: VARCHAR(MAX) Unicode: NVARCHAR(MAX)
Long Character with Raw Binary Image Attachment	IMAGE (ANSI and Unicode)	VARBINARY(MAX) (ANSI and Unicode)

PeopleSoft Field Type

Pre-Conversion Microsoft SQL Server Data Type Mapping

Post-Conversion Microsoft SQL Server Data Type Mapping

Character

ANSI: CHAR

Unicode: NCHAR

ANSI: VARCHAR(n)

Unicode: NVARCHAR(n)

Long Character

ANSI: TEXT

Unicode: NTEXT

ANSI: VARCHAR(MAX)

Unicode: NVARCHAR(MAX)

Long Character with Raw Binary Image Attachment

IMAGE (ANSI and Unicode)

VARBINARY(MAX) (ANSI and Unicode)