Using STRCONV in VFP

[bdenson]

Can anyone give me the syntax for the STRCONV() function in VFP?

I know the VB syntax, but it is different is VFP.

Thanks Guys

Barry Yesterday is history
Tomorrow is a mystery
and todays a gift... ...thats why we call it the present.

 

[mm0000]

STRCONV(cExpression, nConversionSetting [, nLocaleID])

Parameters

cExpression
Specifies the character expression that STRCONV( )converts.

nConversionSetting
Specifies the type of conversion. The following table lists the values of nConversionSetting and the type of conversion performed. nConversionSetting Conversion

1 Converts single-byte characters in cExpression to double-byte characters.

2 Converts double-byte characters in cExpression to single-byte characters.

3 Converts double-byte Katakana characters in cExpression to double-byte Hiragana characters.

4 Converts double-byte Hiragana characters in cExpression to double-byte Katakana characters.

5 Converts double-byte characters to UNICODE (wide characters).

6 Converts UNICODE (wide characters) to double-byte characters.

7 Converts cExpression to locale-specific lowercase.

8 Converts cExpression to locale-specific uppercase.

9 Converts double-byte characters in cExpression to UTF-8

10 Converts Unicode characters in cExpression to UTF-8

11 Converts UTF-8 characters in cExpression to double-byte
characters.

12 Converts UTF-8 characters in cExpression to UNICODE characters.

nLocaleID
Specifies the Locale ID to use for the conversion. If nLocaleID is invalid or not supported on the machine, the error "Invalid locale ID" is generated. If nLocaleID is omitted, the system locale ID is used by default. nLocaleID Language

1029 Czech
1031 German
1033 English (Default)
1034 Spanish
1036 French
1040 Italian
1045 Polish
1046 Portuguese (Brazil)
2070 Portuguese (Portugal)

 

[bdenson]

Thanks!
Yesterday is history
Tomorrow is a mystery
and todays a gift... ...thats why we call it the present.

 

[rgbean]

Barry,
Note: The above syntax applies to VFP 6 & 7, but VFP 5 doesn't support the third parameter (or the 8-12 Conversions). Also, VFP 3 doesn't even have this command.

The point being that it's sometimes very important to include the version (and SP) of the VFP you are working with or interested in.

Rick

 

[21031979]

Hi all,
I'm from Viet Nam, so what's nLocaleID for Vietnamese language ? And how to use STRCONV to store data into VFP database ? Which type of data should be used to store UNICODE data ? The standard control in VFP seem not support UNICODE, what's your solution ? That's all

Thanks for your notice and answer.