SetCodePage Method (SQL-DMO)

The SetCodePage method alters the character set used to interpret data during a bulk copy operation.

Applies To

BulkCopy Object

Syntax

object.SetCodePage( INew , [ UserCodePage ] )

Part Description
object Expression that evaluates to an object in the Applies To list.
INew Long integer or constant specifying the new code page or code page setting method as described in Settings.
UserCodePage Long integer specifying a code page by number as described in Settings.

Settings

Set the INew argument by using these values. If setting INew to SQLDMOBCP_User, set UserCodePage using these values.

Constant Value Description
SQLDMOBCP_RAW -1 Use the installed server code page.
SQLDMOBCP_ACP 0 Use the Microsoft® Windows® default, code page 1252 (ISO 8859-1).
SQLDMOBCP_OEM 1 Use the code page installed on the client. Default value for method. For default behavior for bulk copy operations performed by using SQL-DMO, see Remarks.
SQLDMOBCP_User 2 Use the caller-specified code page. Indicate the code page by number by using the UserCodePage argument.

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 Microsoft SQL Server™ installation during setup.

By default, a bulk copy operation interprets 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.

Prototype (C/C++)

HRESULT SetCodePage(SQLDMO_BCP_CODEPAGE_TYPE NewValue,
long UserCodePage = SQLDMOBCP_OEM);

  


(c) 1988-98 Microsoft Corporation. All Rights Reserved.