Unprintable Characters in Code

  • Hello,

    I recently found some unprintable characters in my stored procedure. I discovered this by beginning to comment out a line and having the whole procedure not compile. I then pasted from QA into Notepad to discover those pesty characters in the code.

    Has anyone else encountered this problem? If so, aside from coding in Notepad, is it possible to avoid having unprintable characters in my SQL code and ensuring that others' code is clean?

    Thank you,

    Melanie

  • This happened to me previously where I was getting the the code for a carriage return and the code looked like it was inline to SQL. I don't remember from where it was coming from but I beleive was due to an app that supported the character version. My only suggest is don't use apps like FrontPage or Visual InterDev to write then copy and paste, as I believe this had to be where the problem started.

    "Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply