#42309 [Asn->Bgs]: select of nvarchar() delivers only the first 250 letters

From: Date: Wed, 15 Aug 2007 17:09:37 +0000
Subject: #42309 [Asn->Bgs]: select of nvarchar() delivers only the first 250 letters
References: 1  Groups: php.bugs 
Request: Send a blank email to php-bugs+get-116129@lists.php.net to get a copy of this message 
 ID:               42309
 Updated by:       fmk@php.net
 Reported By:      bc at ringwald dot name
-Status:           Assigned
+Status:           Bogus
 Bug Type:         MSSQL related
 Operating System: Windows
 PHP Version:      5.2.3
 Assigned To:      fmk
 New Comment:

(n)char and (n)varchar columns has a limit of 256 bytes. This is a
limitation in ntwdblib.dll from Microsoft and can't be fixed in the PHP
extension.

Workaround: use php_dblib.dll as a drop in replacement for
php_mssql.dll. This extension is build on the FreeTDS version of dblib
and does not have the same limitations.


Previous Comments:
------------------------------------------------------------------------

[2007-08-15 15:43:48] jani@php.net

Assigned to the maintainer.

------------------------------------------------------------------------

[2007-08-15 12:58:56] bc at ringwald dot name

Description:
------------
select of nvarchar() delivers only the first 250 letters

workaround: convert(text, attribut)





------------------------------------------------------------------------


-- 
Edit this bug report at http://bugs.php.net/?id=42309&edit=1

Thread (3 messages)

« previous php.bugs (#116129) next »