Re: RE: [PHP-WIN] SQL Server 7 help needed!!!

Hi, >It seems php_mssql.dll uses a MSSQL API called "dbdatlen". This API is not suitable >for text or image fields. In fact, it returns a false text size of 8k (or 4k, depending on the >client libraries and SQL server version you're using), even if there is more data. As you say "dbdatlen" uses the configured max length of text fields. These values can be altered from php.ini mssql.textlimit = 8192 ; valid range 0 - 2147483647 default = 4096 mssql.textsize = 8192 ; valid range 0 - 2147483647 default = 4096 I have testest this with values up to 256kb and it works fine. Users of IE browsers are limited to enter up to 64K in a textarea input field and as you point out using large text columns slows down performence so I would not recomment that. >So I guess some modifications could be made, perhaps using BLOB-specific functions. Personally I >would keep long chunks of text away from a Web app, but handling ir carefully... Modifications are not needed, as the module can handle large text columns! >I'm going to ask the maintainer if some work is currentry being done about this. I'm the maintainer so here is your andwer :-) - Frank