carriage returns and text formatting

[influent]

I imported a Filemaker Pro database into SQL Server, and there is a strange symbol in the data within the two fields that were textboxes. I think they might be carriage returns, but I'm not sure, they look like the male symbol (a circle with an arrow). Can anybody verify that that's what they represent? If I insert data into a SQL Server table from ASP.NET and the data contains carriage returns, will that automatically go in that way, or are returns stripped out? Does it matter if it's VARCHAR or NTEXT, etc.?

thanks in advance, influent

 

[harebrain]

My reference OEM character set suggests that those are VT (vertical tabs) which would be CTRL-K or hex 0B.

Considering the problem you've encountered, there are evidently ways to put any character into a string-type field.

 

[andyrice]

FileMaker lets the user put carriage returns into text fields, I believe.
I needed to strip those out when importing to SQL Server.
In my case, I did that before the import (using a FoxPro program).

Andy Rice
San Diego, CA