Character set

Character set is a file specifier for the LOAD statement that defines the character set used in the file.

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)

See also: