mload and character sets

Tools & Utilities

mload and character sets

Hi im having trouble importing txt data stored in ANSI Windows encoding - exported from Microsoft SQL server via Studio Express.

The charsets possible with mloda -c are ASCII and UTF8. Is there any way to change some parameter so it accepts that file ?

I tried exporting to UTF8 but its still needs ANSI Windows view mode to display properly in Lister (Total commander).

Teradata Employee

Re: mload and character sets


Can you share which error you got when using MLOAD for your case?

If you data file and MLOAD script are in UTF8, you can use "-i utf8 -c  utf8" to MultiLoad the data.