When importing a text file from disk, you can encode the file.
If the file has an initial special Unicode byte order mark (BOM), the file is recognized. Otherwise, the encoding can be set using the Encoding drop-down.
In addition, the following Interactive Reporting Object Model methods accept an additional parameter that sets the input file encoding:
ImportDataFile(String Filename, BqImportDataFileFormat Format, BqEncoding Encoding) ImportSQLFile(String Filename, int numColumns, BqEncoding Encoding) LoadFromFile(String Filename, BqEncoding Encoding)
Table 235. BqEncoding and Values
| BqEncoding | Value |
|---|---|
| bqEnc_Unicode_UTF8 | Unicode with UTF-8 encoding |
| bqEnc_Unicode_UTF16 | 16-bit Unicode – operating system default endian |
| bqEnc_Unicode_UTF16_BigEndian | 16-bit Unicode, most significant byte comes first |
| bqEnc_Unicode_UTF16_LittleEndian | 16-bit Unicode, least significant byte comes first |
| bqEnc_Unicode_UTF32 | 32-bit Unicode – operating system default endianess |
| bqEnc_Unicode_UTF32_BigEndian | 32-bit Unicode, most significant byte comes first |
| bqEnc_Unicode_UTF32_LittleEndian | 32-bit Unicode, least significant byte comes first |
| bqEnc_Arabic_ISO | Arabic languages, ISO encoding (iso-8859-6) |
| bqEnc_Arabic_Windows | Arabic languages, windows encoding (codepage 1256) |
| bqEnc_Baltic_ISO | Baltic languages, ISO encoding (iso-8859-4) |
| bqEnc_Baltic_Windows | Baltic languages, windows encoding (codepage 1257) |
| bqEnc_CentralEuropean_ISO | Central European languages, ISO encoding (iso-8859-2) |
| bqEnc_CentralEuropean_Windows | Central European languages, windows encoding (codepage 1250) |
| bqEnc_Chinese_GBK | Chinese language, GBK encoding |
| bqEnc_Chinese_GB2312 | Chinese language, GB2312 encoding |
| bqEnc_Chinese_HZ | Chinese language, HZ-GB-2312 encoding |
| bqEnc_Cyrillic_DOS | Cyrillic languages, OEM encoding (windows codepage 866) |
| bqEnc_Cyrillic_ISO | Cyrillic languages, ISO encoding (iso-8859-5) |
| bqEnc_Cyrillic_KOI8R | Cyrillic languages, encoding KOI-8R |
| bqEnc_Cyrillic_KOI8U | Cyrillic languages, encoding KOI-8U |
| bqEnc_Cyrillic_Windows | Cyrillic languages, windows encoding (codepage 1251) |
| bqEnc_Greek_ISO | Greek language, ISO encoding (iso-8859-7) |
| bqEnc_Greek_Windows | Greek language, windows encoding (codepage 1253) |
| bqEnc_Hebrew_Windows | Hebrew language, windows encoding (codepage 1255) |
| bqEnc_Japanese_EUC | EUC - Japanese |
| bqEnc_Japanese_JIS | Japanese, JIS |
| bqEnc_Japanese_ShiftJIS | Japanese, Shift-JIS |
| bqEnc_Korean | Korean (Unified Hangul Code) |
| bqEnc_Thai_Windows | Thai language, windows encoding (codepage 874) |
| bqEnc_Turkish_ISO | Turkish language, ISO encoding (iso-8859-2) |
| bqEnc_Turkish_Windows | Turkish language, windows encoding (codepage 1254) |
| bqEnc_WesternEuropean_ISO | Western European languages, ISO encoding (iso-8859-9) |
| bqEnc_WesternEuropean_Windows | Western European languages, windows encoding (codepage 1252) |
| bqEnc_Vietnamese_Windows | Vietnamese language, windows encoding (codepage 1258) |