Justtechjobs.com Find a programming school near you






Online Campus Both


php-db | 2001041

[PHP-DB] mssql - unable to read large text fields From: Manuel Prieur (manuel.prieur <email protected>)
Date: 04/11/01

Hello,

I'd like to use PHP4 on IIS to access a MSSQL7 server, but i have problems
reading large text fields :

- "nvarchar" fields are truncated to 255 chars.

- "ntext" fields generated the following error message :

>>>
Warning: MS SQL message: Impossible d'envoyer les données ntext aux clients
utilisant DB-Library (par exemple ISQL) ou ODBC version 3.7 ou antérieure.
(severity 16)
<<<
(English : Unable to send ntext data to clients using DB-Library (for
instance ISQL) or ODBC version 3.7 or previous.)

I also tried to use built-in ODBC driver :

- "nvarchar" fields have correct size.

- "ntext" fields generate the following error message :

>>>
FATAL: emalloc(): Unable to allocate 1073741824 bytes
<<<

Thanks for help.

Manuel Prieur.

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-db-unsubscribe <email protected>
For additional commands, e-mail: php-db-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>