SQL CR LF's - how to duplicate
Posted on 2005-03-03
My SQL DB has some hidden characters (13,10), but only in a couple of records. The records come in from a website. I'm puzzled on how they got there and all the others are fine. I cannot create a record online and duplicate the CRLF's in the SQL DB. I do have wordwrap on - even though it won't let you go to the next line. On enter, the "next" button is pushed.
If I type in some of the fields and hit enter - it goes to the next page - but in my SQL DB, there still isn't a CRLF. I need to be able to duplicate this to make sure that turning off wordwrap fixes it.
Any ideas? I tried ^M and ^J for the CRLF and it still doesn't insert it into the DB from the website.