I'm completely new to using Microsoft SQL Server. I'm running SQL Server 2000 Personal Edition on a machine at work on Win2k w/ IIS 5.0 and the latest version of PHP.
My problem is this: I have a table w/ over 3,000 records in it and 5 fields. This table contains questions to a DRILL program that I am to be putting on a University website for students to take practice quizzes on. The field type for the question is set to "ntext" and length 16. Now, I get an error saying that the server can't send ntext fields. So, I tried multiple field types: nvarchar, length 400; varchar, length 400; and text, length 16. The type that worked best was text. Now each of these fields with a question in it will contain any one of these things: characters, numbers, #, !, -, ', :, %, &, and (). I made a PHP script to query the db and out put the entire table in a web browser. Everything comes out fine, except 6 records that contain quite a few more characters than it will allow to be sent. When I look in the database under SQL Enterprise Manager and view all rows to that table. Everything is there for those 6 records. How can I get the stuff that is being chopped off when sent to the browser, to NOT be chopped off?
I know this is long and maybe confusing, but all and any help is appreciated. Thanks!
