Skip to main content Skip to complementary content

Character set

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:  

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!