MS SQL problems

[Anon]

Hi there,

I have a really annoying problem. I use PHP on a Windows NT server with IIS, which works perfectly fine (yes, I was amazed that it did ;-) I prefer Linux/Unix ;-)). I can access the MS SQL database that is being run overthere with no big problems and everything SEEMED to work just fine. But I found something which I just can't get to work right. This is the problem:

I use a textfield to store HTML code (which later is used to generate a website on the fly) and although this seemed to work fine, it doesn't. The problem is that there seems to be a maximum amount of text that can be displayed. I checked the MS SQL manuals and these manuals all talked about a 4 kB limit, which can easily be raisen to a bigger limit. Well, the 4 kB limit is there allright but there's no way to raise it. I used the SET TEXTSIZE 1024000 option, but nope, won't work either. If you set the textsize to, let's say, 10, it will work. Make it bigger than 4 kb and it will still just show the first 4 kb.

Ad you might understand, this is NOT what I want. If anyone has experienced a similar problem, please let me know. And if you have a solution, that would be SO great ;-) I'd kiss you for it ;-)

[Anon]

I was able to use a separate

SET TEXTSIZE 1000000

query first, and then proceed with the extraction query. Be sure you try it on the INSERT query too, I don't remember whether I needed that. However, I know I was able to store over 500k in a single field in our MS SQL 6.5 database without a problem (except magic quotes being on by mistake and trashing my data!!!)

Chris

Michiel wrote:

Hi there,

I have a really annoying problem. I use PHP on a Windows NT server with IIS, which works perfectly fine (yes, I was amazed that it did ;-) I prefer Linux/Unix ;-)). I can access the MS SQL database that is being run overthere with no big problems and everything SEEMED to work just fine. But I found something which I just can't get to work right. This is the problem:

I use a textfield to store HTML code (which later is used to generate a website on the fly) and although this seemed to work fine, it doesn't. The problem is that there seems to be a maximum amount of text that can be displayed. I checked the MS SQL manuals and these manuals all talked about a 4 kB limit, which can easily be raisen to a bigger limit. Well, the 4 kB limit is there allright but there's no way to raise it. I used the SET TEXTSIZE 1024000 option, but nope, won't work either. If you set the textsize to, let's say, 10, it will work. Make it bigger than 4 kb and it will still just show the first 4 ....