1. 

   hpcalaf, Member

   I have the need to display a lengthy body of text.

   Whether I try to display text via dbr.text, dbr.purehtml or just a select statement with text in quotes (ie. select 'text') they all truncate after about 250 characters in the web page display. Is this an issue of the class that used to display the select? I just want to over-ride the length, so need advice about what class is being used if that is the issue.

   Thanks
2. 

   myDBR Team, Key Master

   If you are using MS SQL Server check the 'text size' setting in your freetds.conf. It determines the maximum length of the column.

   --
   myDBR Team
3. 

   hpcalaf, Member

   Converted to "TEXT" datatype and it worked. http://www.freetds.org/userguide/troubleshooting.htm#TEXTFIELDS

   Thanks
4. 

   myDBR Team, Key Master

   Make also sure you have the correct TDS version (8.0) defined in your freetds.conf. If your settings are ok, you should not need to make any conversions to get long texts working.

   --
   myDBR Team

Reply

You must log in to post.