<Long Text> doesn't show up - SQL Server Forums

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.

All Forums

General SQL Server Forums

New to SQL Server Programming

<Long Text> doesn't show up

Author

Topic

live life
Starting Member

6 Posts

Posted - 2006-03-21 : 10:34:08

I have a question that has a co-worker and myself confused. We are using the SQL Server Enterprise Manager. When I select return all rows in my tables, any content that is too long will appear as <Long Text> on my co-workers machine, but the column is blank on my machine. Is there a property or configuration that enables/disables <Long Text>? I am confused as to why it appears on other machines, but not mine.

Your help is appreciated.

Live Life.

afrika
Master Smack Fu Yak Hacker

2706 Posts

Posted - 2006-03-21 : 11:05:38

Welcome to SQLTeam.

Thats always the problem with text datatype, I would advice you to change to varchar (8000), but one question: How much data are you storing ?

Afrika

live life
Starting Member

6 Posts

Posted - 2006-03-21 : 12:17:40

Afrika,

Thanks for the welcome and the quick reply. I will try your advice.

To answer your question, I have a developed a site using a content management system which of course connects to a SQL database. The amount of data/text stored depends on how much the client will add to the editable regions.

Thanks for your help.
Live Life

afrika
Master Smack Fu Yak Hacker

2706 Posts

Posted - 2006-03-21 : 12:41:54

Yeah,
But what length of characters are you looking at ?

varchar handles a maximum of 8000, thats why i asked.

jen
Master Smack Fu Yak Hacker

4110 Posts

Posted - 2006-03-22 : 00:28:14

use query analyzer to query the data

enterprise manager has its limits

HTH

--------------------
keeping it simple...

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2006-03-22 : 00:30:20

Also show them in your Front End application if any

Madhivanan

Failing to plan is Planning to fail

jkgiven
Starting Member

1 Post

Posted - 2006-04-10 : 11:56:04

I have the same long text issue - just don't understand it. What if it is more than 8000 characters?

I put in 8000 characters in a varchar field, and it only displayes 1004 - where did the rest go? EDIT - Is it 8000 bytes instead of 8000 characters?

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2006-04-10 : 15:33:04

The original issue has to do with Enterprise Manager. You can view this data in Query Analyzer. It isn't a problem with text data type.

Tara Kizer
aka tduggan

jen
Master Smack Fu Yak Hacker

4110 Posts

Posted - 2006-04-10 : 21:02:13

in QA, if the result still gets truncated, verify
QA\Tools\Options\results tab\maximum characters per column

and modify if not enough

HTH

--------------------
keeping it simple...

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources