I’ve just started to use MySQLi (I normally just use MySQL Connect, etc) and have encountered a problem.
If I fetch some data from a table, even if the field is of the type ‘text’, it is truncated to a maximum of 256 characters.
Someone else is having a similar issue: http://www.jodymickey.com/?p=38
Any help is appreciated!
It’s got to be an issue on your end. MySQLi doesn’t truncate the results, unless you specify so. Can you paste in some code?
may be its an input validation
text datatype is too big , cant be limited at 256
You can also Try Blob. Make sure , Input is not being processed some where.
I’ll just put an example up on github in a second and post a link here…
Has anyone had a chance to look at this?
I have tested your script on my localhost. Both scripts gave me the exact the same output:
“Number of characters in body field: 3493”
So the problem must be somewhere else.