4D v14.3
CONVERT FROM TEXT
- 4D Language Reference
-
- String
-
- Character Reference Symbols
- Change string
- Char
- Character code
- CONVERT FROM TEXT
- Convert to text
- Delete string
- Get localized string
- GET TEXT KEYWORDS
- Insert string
- Length
- Lowercase
- Match regex
- Num
- Position
- Replace string
- String
- Substring
- Uppercase
- Convert case
- ISO to Mac
- Mac to ISO
- Mac to Win
- Win to Mac
CONVERT FROM TEXT
| CONVERT FROM TEXT ( 4Dtext ; charSet ; convertedBLOB ) | ||||||||
| Parameter | Type | Description | ||||||
| 4Dtext | String |
|
Text expressed in current character set of 4D | |||||
| charSet | String, Longint |
|
Name or Number of character set | |||||
| convertedBLOB | BLOB |
|
BLOB containing converted text | |||||
The CONVERT FROM TEXT command can be used to convert a text expressed in the current character set of 4D to a text expressed in another character set.
In the 4Dtext parameter, pass the text to be converted. This text is expressed in the character set of 4D. In version 11, 4D uses the Unicode character set by default.
In charSet, pass the character set to be used for the conversion. You can pass a string containing the standard name of the set (for example “ISO-8859-1” or “UTF-8”), or its MIBEnum identifier.
Here is a list of character sets supported by the CONVERT FROM TEXT and Convert to text commands:
| MIBEnum | Name(s) |
| 1017 | UTF-32 |
| 1018 | UTF-32BE |
| 1019 | UTF-32LE |
| 1015 | UTF-16 |
| 1013 | UTF-16BE |
| 1014 | UTF-16LE |
| 106 | UTF-8 |
| 1012 | UTF-7 |
| 3 | US-ASCII |
| 3 | ANSI_X3.4-1968 |
| 3 | ANSI_X3.4-1986 |
| 3 | ASCII |
| 3 | cp367 |
| 3 | csASCII |
| 3 | IBM367 |
| 3 | iso-ir-6 |
| 3 | ISO_646.irv:1991 |
| 3 | ISO646-US |
| 3 | us |
| 2011 | IBM437 |
| 2011 | cp437 |
| 2011 | 437 |
| 2011 | csPC8CodePage437 |
| 2028 | ebcdic-cp-us |
| 2028 | cp037 |
| 2028 | csIBM037 |
| 2028 | ebcdic-cp-ca |
| 2028 | ebcdic-cp-n |
| 2028 | ebcdic-cp-wt |
| 2028 | IBM037 |
| 2027 | MacRoman |
| 2027 | x-mac-roman |
| 2027 | mac |
| 2027 | macintosh |
| 2027 | csMacintosh |
| 2252 | windows-1252 |
| 1250 | MacCE |
| 1250 | x-mac-ce |
| 2250 | windows-1250 |
| 1251 | x-mac-cyrillic |
| 2251 | windows-1251 |
| 1253 | x-mac-greek |
| 2253 | windows-1253 |
| 1254 | x-mac-turkish |
| 2254 | windows-1254 |
| 1256 | x-mac-arabic |
| 2256 | windows-1256 |
| 1255 | x-mac-hebrew |
| 2255 | windows-1255 |
| 1257 | x-mac-ce |
| 2257 | windows-1257 |
| 17 | Shift_JIS |
| 17 | csShiftJIS |
| 17 | MS_Kanji |
| 17 | Shift-JIS |
| 39 | ISO-2022-JP |
| 39 | csISO2022JP |
| 2026 | Big5 |
| 2026 | csBig5 |
| 38 | EUC-KR |
| 38 | csEUCKR |
| 2084 | KOI8-R |
| 2084 | csKOI8R |
| 4 | ISO-8859-1 |
| 4 | CP819 |
| 4 | csISOLatin1 |
| 4 | IBM819 |
| 4 | iso-ir-100 |
| 4 | ISO_8859-1 |
| 4 | ISO_8859-1:1987 |
| 4 | l1 |
| 4 | latin1 |
| 5 | ISO-8859-2 |
| 5 | csISOLatin2 |
| 5 | iso-ir-101 |
| 5 | ISO_8859-2 |
| 5 | ISO_8859-2:1987 |
| 5 | l2 |
| 5 | latin2 |
| 6 | ISO-8859-3 |
| 6 | csISOLatin3 |
| 6 | ISO-8859-3:1988 |
| 6 | iso-ir-109 |
| 6 | ISO_8859-3 |
| 6 | l3 |
| 6 | latin3 |
| 7 | ISO-8859-4 |
| 7 | csISOLatin4 |
| 7 | ISO-8859-4:1988 |
| 7 | iso-ir-110 |
| 7 | ISO_8859-4 |
| 7 | l4 |
| 7 | latin4 |
| 8 | ISO-8859-5 |
| 8 | csISOLatinCyrillic |
| 8 | cyrillic |
| 8 | ISO-8859-5:1988 |
| 8 | iso-ir-144 |
| 8 | ISO_8859-5 |
| 9 | ISO-8859-6 |
| 9 | arabic |
| 9 | ASMO-708 |
| 9 | csISOLatinArabic |
| 9 | ECMA-114 |
| 9 | ISO-8859-6:1987 |
| 9 | iso-ir-127 |
| 9 | ISO_8859-6 |
| 10 | ISO-8859-7 |
| 10 | csISOLatinGreek |
| 10 | ECMA-118 |
| 10 | ELOT_928 |
| 10 | greek |
| 10 | greek8 |
| 10 | iso-ir-126 |
| 10 | ISO_8859-7 |
| 10 | ISO_8859-7:1987 |
| 11 | ISO-8859-8 |
| 11 | csISOLatinHebrew |
| 11 | hebrew |
| 11 | iso-ir-138 |
| 11 | ISO_8859-8 |
| 11 | ISO_8859-8:1988 |
| 12 | ISO-8859-9 |
| 12 | csISOLatin5 |
| 12 | iso-ir-148 |
| 12 | ISO_8859-9 |
| 12 | ISO_8859-9:1989 |
| 12 | l5 |
| 12 | latin5 |
| 13 | ISO-8859-10 |
| 13 | csISOLatin6 |
| 13 | iso-ir-157 |
| 13 | ISO_8859-10 |
| 13 | ISO_8859-10:1992 |
| 13 | l6 |
| 13 | latin6 |
| 109 | ISO-8859-13 |
| 111 | ISO-8859-15 |
| 111 | Latin-9 |
| 113 | GBK |
| 2025 | GB2312 |
| 2025 | csGB2312 |
| 2025 | x-mac-chinesesimp |
| 2024 | Windows-31J |
| 57 | GB_2312-80 |
| 57 | csISO58GB231280 |
Note: Several rows have the same MIBEnum identifier because a character set can have more than one name (alias).
For more information about the names of character sets, please refer to the following address: http://www.iana.org/assignments/character-sets
After execution of the command, the converted text will be returned in the convertedBLOB BLOB. This BLOB can be read by the Convert to text command.
If the command has been correctly executed, the OK variable is set to 1. Otherwise, it is set to 0.
Product: 4D
Theme: String
Number:
1011
Created: 4D v11 SQL
4D Language Reference ( 4D v12.4)
4D Language Reference ( 4D v14 R3)
4D Language Reference ( 4D v14 R2)
4D Language Reference ( 4D v13.5)
4D Language Reference ( 4D v14.3)
4D Language Reference ( 4D v14 R4)
Parent of : CONVERT FROM TEXT ( 4D v11 SQL Release 6)
