Character set is a file specifier for the LOAD statement that defines the character set used in the file.
The ansi, oem and mac specifiers were used in QlikView and will still work. However, they will not be generated when creating the LOAD statement with Qlik Sense.
Syntax:
utf8 | unicode | ansi | oem | mac | codepage is
Arguments:
| Argument | Description |
|---|---|
| utf8 | UTF-8 character set |
| unicode | Unicode character set |
|
ansi |
Windows, codepage 1252 |
| oem |
DOS, OS/2, AS400 and others |
| mac | Codepage 10000 |
| codepage is |
With the codepage specifier, it is possible to use any Windows codepage as N . |
Limitations:
Conversion from the oem character set is not implemented for MacOS. If nothing is specified, codepage 1252 is assumed under Windows.
Example:
LOAD * from a.txt (utf8, txt, delimiter is ',' , embedded labels)
LOAD * from a.txt (unicode, txt, delimiter is ',' , embedded labels)
LOAD * from a.txt (codepage is 10000, txt, delimiter is ',' , no labels)
Learn more
Did this page help you?
If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!