Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Datalength problem

Status
Not open for further replies.

aspx

Programmer
Jul 25, 2002
52
BG
Hi!
I have field in the database which should accept text (Unicode) with different size. First I set this field to be nvarchar(3000) and I've attempted to put some text (about 2000 symbols) in that field with PHP. Then I tried to view the saved text using again PHP. For my suprise the length of the text was about 100 symbols?! (I changed the type of the field to varchar(5000) but I got the same effect:(().
Again I changed the type of the field to text - but only about first 1000 symbols were saved?!
Using ntext PHP and MSSQLServer simply refused to work...

Win2kAdvancedServer / MSSQLServer2KEnterprise / PHP4.2.3 / Apache2.0.43
 
I found the problem - it was in the configuration of PHP (default maxsize of query=4KB).
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top