CodePage Property (SQL-DMO)

The CodePage property returns the identifier of the character set used by the referenced Microsoft® SQL Server™ installation or is used to interpret data for a bulk-copy operation.

Applies To

BulkCopy Object

SQLServer Object

Syntax

object.CodePage

Part	Description
object	Expression that evaluates to an object in the Applies To list

Remarks

A character set (code page) is used to interpret multibyte character data, determining character value, and therefore sort order. Code page settings apply only to multibyte character data, not to Unicode character data. A code page is chosen for a SQL Server installation during setup.

By default, bulk-copy operations interpret character data assuming the code page used by the SQL Server installation that is either the source or the destination for the copied data. This default behavior can be changed by using the SetCodePage method.

Data Type

Long

Modifiable

Read-only

Prototype (C/C++)

HRESULT GetCodePage(LPLONG pRetVal);