sometimes it takes decades to clean up MS shit.

From /etc/freetds/freetds.conf
    # If you get out of memory errors, it may mean that your client
    # is trying to allocate a huge buffer for a TEXT field.
    # (Microsoft servers sometimes pretend TEXT columns are
    # 4 GB wide!) If you have this problem, try setting
    # ‘text size’ to a more reasonable limit

If you ever get

Fatal error: Allowed memory size of 25165824 bytes exhausted (tried to allocate 2147483647 bytes) in /var/www/deneme.php on line 4

error on any mssql_query call when using php4_sybase or php4_mssql package compiled with freetds (on debian systems), just insert
    text = <any reasonable text buffer size in bytes>
    ; likely text = 65535
to /etc/fredts/freedts.conf global section.

It, took me hours to find out the difference on two identical servers.. I even compared any library on strace “php4 mssql.php” output!

And thank you Mükremin for your help for watching me
And also special awards goes to;
   Yalçın just talking unreasonablely shit. :)


Etiketler: