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:

 

Did this information help you?

Thanks for letting us know. Is there anything you'd like to tell us about this topic?

Can you tell us why it did not help you and how we can improve it?