CodePage Property
未來的 Microsoft SQL Server 版本將移除這項功能。請避免在新的開發工作中使用這項功能,並規劃修改目前使用這項功能的應用程式。
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.
語法
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);
備註
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.