You are here: Re: Question Using MSSQL_QUERY « PHP Programming Language « IT news, forums, messages
Re: Question Using MSSQL_QUERY

Posted by Erwin Moller on 11/22/05 15:57

Gazchurchend wrote:

> Hi
>
> Ive been using PHP to query data from SQL Server using MSSQL_QUERY for
> a while now, but recently noticed a problem. I have a notes field in
> the database (varchar 6000) for entering text. When reading out the
> data with a simple SELECT statement I noticed it would only get 256
> characters in the MSSQL_FETCH_ARRAY result. Don't know how I missed
> this before. Obviously a significant number!
> I checked the INI file for any settings. The MSSQL.TEXTSIZE and
> MSSQL.TEXTLIMIT are both set to maximum limits, if this has anything to
> do with it.
>
> Does anyone know how to get round this problem, I have tried all the
> getting methods I know all of which do the same.
>
> Thanks in advance.

Hi,

Maybe this helps:
[http://expertanswercenter.techtarget.com/eac/expertAnswer/0,295208,sid63_gci1051984,00.html]

DB-Library applications and applications using the SQL Server ODBC drivers
from SQL Server version 6.5 or earlier support only a maximum of 255 bytes
of character data. If these applications attempt to retrieve character
parameters of SQL Server version 7.0 or later, or result set columns
containing more than 255 bytes of data, the character data is truncated at
255 bytes.

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

I once had the same problem under IIS with VBscript. Upgrading the drivers
helped solving it.
Look at M$-site for a MDAC upgrade.

Good luck,
Erwin Moller

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация