its not any specific code. but when a user types a remark into a textarea on my site, and they put carriage returns in their remark, the carriage returns are ignored when the information is saved to the database. do i need to do some text manipulation before it is saved, or is there an easier way to just save what they typed in?
Sorry, I'm confusing two different posts (ignore the whole quote thing).
If you are storing your data in either a VARCHAR or NVARCHAR field, it should maintain any CR in you data. If they are not appearing, it is because they are not making it into the database. It's possible that the textbox is not storing/sending them, or that they are being eliminated somewhere else in your code.
Look for a function call either in the same command that send the data to the server, or right before it. I actually had to implement something like this on certain fields, like name and address, in order to eliminate the wrapping on the labels.
Don't know if this will be any help, but. I have several tables that have type varchar and are feed data via asp. From what I have seen, the data recognizes the carriage return as if you copy and paste the data into ms word, excel, or even notepad it uses the carriage return. response.write does not "see" it, however if you return the value in a text box it will "see" the return. for what it is worth! I edited this and pasted the value of a varchar (255) below is the result. In excel the CR looks like a square. again for what it is worth