Converts character or memo fields or character expressions to another code page.

 
CPCONVERT(nCurrentCodePage, nNewCodePage, cExpression)
 


Parameters
nCurrentCodePage
Specifies the code page that cExpression is being converted from.

nNewCodePage
Specifies the code page to which cExpression is converted.

cExpression
Specifies the character expression that's converted.

Remarks
Note that CPCONVERT( ) isn't required for normal cross-platform functioning of the product. It is used strictly to access the underlying translation facilities of Visual FoxPro.

For example, if the variable gcCharExpr contains a character that looks like on the Macintosh (in code page 10000) then CPCONVERT( ) will return a character that looks like in Microsoft Windows (code page 1252):

  Copy Code 
CPCONVERT(10000, 1252, gcCharExpr)

select convert(866, 1251, field1) as f1 from table where ....

select cast(cpconvert(866, 1251, BCONTENT) as M) from [books]