Re: SQL Server 7 help needed!!!

Hello Paco! >...returns a false text size of 8k (or 4k, depending on the client libraries and SQL server >version you're using) Would you please be so kind and tell me the "versions" to be able to get 8k out, so that I can ask my IT-dept. to realsize that? Many thanks in advance, Thomas Paco Ortiz wrote: > Hi: > > I reply to myself: > > > I'll take a look to the source code of php_mssql.dll, perhaps there is a limit > > >when allocating the buffers for the resultset. > > 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. > > 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... > > I'm going to ask the maintainer if some work is currentry being done about this. > > You also have to ask yourself if you really need to handle those amounts of data. Perhaps you > have to establish a limitation or split your data among several columns (yeah, I know, I know, but > if you are desperate...) > > Greetings, > > Paco