Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Express Edition and Compact Edition (2005)
 sql varchar datatype

Author  Topic 

ddon07
Starting Member

2 Posts

Posted - 2007-11-06 : 04:40:35
hello,
i am using varchar(max) for my column story

I have also tried nvarchar(max) but what is happening is where ever there is enter pressed in the story it stores text till that area only.

well presently iam entering data(copy paste) directly in my database.

later fnctionality will include online insertion of all the dta including stories. these stories are between 500-800 character.

how do i solve it

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-11-06 : 05:04:28
I think this is a presentation problem only.
Are you [by chance] using GRID MODE in SSMS?

Try to switch to TEXT MODE and see if there is a difference.



E 12°55'05.25"
N 56°04'39.16"
Go to Top of Page
   

- Advertisement -