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]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! |
Welcome Guest, Not a member yet? Register Sign In |