mload and character sets

Tools
Fan

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).

1 REPLY
Teradata Employee

Re: mload and character sets

Hi,

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.

Thanks!

--Ivy.