Reply to Re: How do I use SELECT on a column with datatype TEXT?

Your name:

Reply:


Posted by Bob Barrows [MVP] on 12/20/05 21:46

gene.ellis@gmail.com wrote:
> Hello. I using a simply SELECT statement to retrieve some data from a
> SQL SERVER via an ODBC connection. I had to go from VARCHAR to TEXT
> because the amount of data. Anyway, my SQL statements worked just fine
> when I was using VARCHAR, but now since I am using TEXT, I am only
> receiving part of the content back. Do I have to do some sort of
> special Casting or something if I want to get all the content back?
> It's over 8,000 characters. Thank you very much. I have racking my
> brain on this for a while.

Let me guess: you're testing this in QA and noticing that the TEXT data is
truncated ...?
If so, go into the Options dialog and uncheck the option to truncate TEXT
results.

Bob Barrows
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

[Back to original message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация