Wednesday, October 26, 2022

[SOLVED] '^M' character at end of lines

Issue

When I run a particular SQL script in Unix environments, I see a '^M' character at the end of each line of the SQL script as it is echoed to the command line.
I don't know on which OS the SQL script was initially created.

What is causing this and how do I fix it?


Solution

It's caused by the DOS/Windows line-ending characters. Like Andy Whitfield said, the Unix command dos2unix will help fix the problem. If you want more information, you can read the man pages for that command.



Answered By - Thomas Owens
Answer Checked By - Mary Flores (WPSolving Volunteer)