When I ftp a text file to the unix server, all the carriage returns are represented by some characters. As a result when I load this file into my oracle database, the last column contains some unreadable characters and my select queries fail.

The only way of preventing this to open the file in textpad and save it for Unix. Then everything goes well as intended.

How do I do this without using textpad? Can this be done in notepad for instance.