|Article Time Stamp: 25 February 2009, 23:19:04 GMT+7|
Microsoft SQL (MSSQL): Display Field's Values Only Showing Maximal 256 Characters
You use Microsoft SQL 2000 Query Analyzer and you already insert some values with more than 256 Character into your table. But when you display the field's values, it only show 256 character length, and the rest of the values is gone.
Don't worry, your table still have the original values, but you must change the MS SQL 2000 Query Analyzer settings, so it can display more than 256 characters.
Just do these following:
1. Open MS SQL 2000 Query Analyzer
2. At Tools Menu, choose Option
3. Select the "Results" tab
4. Change "Maximum characters per column" to something else