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.
| Author |
Topic |
|
Ali.M.Habib
Yak Posting Veteran
54 Posts |
 Posted - 2009-04-27 : 09:02:08
|
| I want to enter data with lenght greater than 4000 char so I chossed ntext but when insert data like :"my name is Ali, Have the following data:1. dddd3.fff4.rrthe end"just insert my name is Ali, Have the following data: only how can insert data with same formate without lossing data |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-04-27 : 09:13:53
|
Are you using GRID MODE in your query window?Change to TEXT MODE and your crlf are back.
E 12°55'05.63"N 56°04'39.26" |
 |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-04-27 : 09:17:15
|
Also, with SQL Server 2005, you can use NVARCHAR(MAX) instead of NTEXT.
E 12°55'05.63"N 56°04'39.26" |
|
|
|
Ali.M.Habib
Yak Posting Veteran
54 Posts |
Posted - 2009-04-27 : 09:26:02
|
quote:
Originally posted by Peso
Also, with SQL Server 2005, you can use NVARCHAR(MAX) instead of NTEXT.
E 12°55'05.63"N 56°04'39.26"
the data is < 4000 charachter , and nvarchar(max) hold only 4000 char |
|
|
|
TG
Master Smack Fu Yak Hacker
6065 Posts |
Posted - 2009-04-27 : 10:29:55
|
| nvarchar(max) was added to replace ntext. It allows more that 4000 charactersBe One with the OptimizerTG |
|
|
|
|
|
|
I need ur help