Jaa


CodePage Property

This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.

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

Syntax

object
.CodePage

Parts

  • object
    An expression that evaluates to an object in the Applies To list

Data Type

Long

Modifiable

Read-only

Prototype (C/C++)

HRESULT GetCodePage(LPLONG pRetVal);

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 an instance of SQL Server during setup.

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

Applies To:

BulkCopy Object

SQLServer Object

See Also

Reference

SetCodePage Method

Help and Information

Getting SQL Server 2005 Assistance