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 |
|
yaman
Posting Yak Master
213 Posts |
 Posted - 2009-06-30 : 05:29:47
|
| Hello Sir , I have a column 'RESUME TEXT ' nvarchar(max)& i am store 18 HTML pages resume in that coloumn .But it store only 12 pages .Pls help me out sir .....Yaman |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-06-30 : 06:24:13
|
Help you out with what?You already have the column as NVARCHAR(MAX).
N 56°04'39.26"E 12°55'05.63" |
 |
|
|
Transact Charlie
Master Smack Fu Yak Hacker
3451 Posts |
Posted - 2009-06-30 : 06:56:43
|
| Are you maybe seeing truncation of the output?Try doing SELECT LEN([resume Tex]) to see how many characters are in the column and then compare that to whatever output yoare getting.It could be that you are running into an implicit or explicit conversion that you are unaware of. Or that you have set a truncation length for results.Charlie===============================================================Msg 3903, Level 16, State 1, Line 1736The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION |
|
|
|
|
|
|
Data type for Large Text Object