Help - I can not retrieve string greater than 255 caracters

[eluser]Narkboy[/eluser]
Solution: change any VARCAHR() fields over 255 to TEXT().


http://www.php.net/manual/en/function.ms...length.php

In the notes section:

"Due to a limitation in the underlying API used by PHP (MS DBLib C API), the length of VARCHAR fields is limited to 255. If you need to store more data, use a TEXT field instead."


Note that TEXT() fields may give you a performace hit when searching and comparing and they can't be used for '=' or GROUP BY clauses.


/B

[eluser]Pau1inh0[/eluser]
Thanks ... I used the conversion to TEXT and it worked, it really is a limitation of the type VARCHAR in PHP.

[eluser]WanWizard[/eluser]
No, it's a limitation of the MS DBlib API (which is old, from Sybase days...).

[eluser]Pau1inh0[/eluser]
thanks...

[eluser]Narkboy[/eluser]
If you're able to, I would reccomend that you migrate to MySQL, for a whole host of reasons. The Community Server is free to all, and help and support are very easy to find!