Datatype TEXT won't display - 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

SQL Server 2000 Forums

SQL Server Development (2000)

Datatype TEXT won't display

Author

Topic

oahu9872
Posting Yak Master

112 Posts

Posted - 2006-01-26 : 08:15:00

I need to store large amounts of text in a database, so I am using the datatype text instead of varchar because of varchar's 8000 character limit.

my problem is when i converted the field to text, the data no longer displays on the website. i checked the database and it is still there.

any ideas on why this happens or how to get around it?

thanks

Srinika
Master Smack Fu Yak Hacker

1378 Posts

Posted - 2006-01-26 : 08:18:17

Just a suggestion
U can save text in a text file in the computer (not in the database) and have a column in the database/table to keep the path.name of the files

oahu9872
Posting Yak Master

112 Posts

Posted - 2006-01-26 : 08:23:05

that's interesting, i haven't thought of doing that. how exactly would i get it to display text from a text file? i'm guessing in the database field i put an include statement and lead it to the text file, does that sound right?

thanks

Srinika
Master Smack Fu Yak Hacker

1378 Posts

Posted - 2006-01-26 : 08:36:45

Ur front end application can be used to display the text file / word file / excel file ... if the client has appropriate tool to open such.

eg. U can keep a file in Excel(xls) or Text(txt) or Word(doc) format in a Server and the Clients can read that using file opening methods.

What is ur requirement?
What is ur front end?

oahu9872
Posting Yak Master

112 Posts

Posted - 2006-01-26 : 08:41:11

I need the clients to be able to open a page in their website and see the text displayed on the page. the text comes from a database field. i tried putting in the database field this code...



and also...



neither worked. i'm not sure if i did it wrong or not.

ditch
Master Smack Fu Yak Hacker

1466 Posts

Posted - 2006-01-26 : 08:46:14

how about storing the text files as html files instead of text files.
That way they can easily be displayed on the website.

ie storing teststory.htm as opposed to teststory.txt.

Duane.

Srinika
Master Smack Fu Yak Hacker

1378 Posts

Posted - 2006-01-26 : 09:06:40

oahu9872,

ditch is correct.

C how do u display an html page
eg. response.redirect("http://www.urWebsite.com/AnyPage.htm")
or keep all files in a folder & use
response.redirect("http://www.urWebsite.com/Myfolder/AnyPage.htm")

or u can have any other way as link ...
U can use either HTML or ASP
I think u can show Word / Excel / Text using the internet explorer ... also without changing to html, using the same method

oahu9872
Posting Yak Master

112 Posts

Posted - 2006-01-26 : 09:29:09

I'm not having much luck getting this to work. Does anyone know why it won't just display on the site when its saved in the database as a text datatype? i already have the data in there so if i could just get that datatype to display it would be much simpler.

druer
Constraint Violating Yak Guru

314 Posts

Posted - 2006-01-26 : 09:39:56

TEXT data needs to be read/handled differently than CHAR data. Depending on what front end coding you are using you'll need to refer to see how to read TEXT datafields back from the database.

Srinika
Master Smack Fu Yak Hacker

1378 Posts

Posted - 2006-01-26 : 09:54:42

oahu9872,

If u need the files approach, let me know

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources