PHP :: Bug #42309 :: select of nvarchar() delivers only the first 250 letters

Bug #42309	select of nvarchar() delivers only the first 250 letters
Submitted:	2007-08-15 12:58 UTC	Modified:	2007-08-15 17:09 UTC
From:	bc at ringwald dot name	Assigned:	fmk (profile)
Status:	Not a bug	Package:	MSSQL related
PHP Version:	5.2.3	OS:	Windows
Private report:	No	CVE-ID:	None

View Add Comment Developer Edit

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

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

workaround: convert(text, attribut)

Patches

Add a Patch

Pull Requests

Add a Pull Request

History

AllCommentsChangesGit/SVN commitsRelated reports

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

Assigned to the maintainer.

[2007-08-15 17:09 UTC] fmk@php.net

(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.

	php.net \| support \| documentation \| report a bug \| advanced search \| search howto \| statistics \| random bug \| login
go to bug id or search bugs for


Copyright © 2001-2024 The PHP Group All rights reserved.	Last updated: Thu Apr 25 00:01:41 2024 UTC