how to show more than 1900 char from Mysql db

Question

i have a mysql db with table by "medium text" and "utf8 general ci" collation .. when i put more than 1900 char in it i can not retrive data from it .. how can i fix it to be dynamic if i fill it by any num of chars

Answer 1

I'm guessing you would probably still be able to retrieve the data even if encoding was the issue, only problem is, that the characters are not encoded correctly, you probably get those as weird looking characters instead of what you originally store in the table. Looking forward to a good solution for this ...

Answer 2

What error are you getting? Is the field type "TEXT"?

Answer 3

Can you change it to TEXT?

Answer 4

Or maybe LONGTEXT

Answer 5

https://stackoverflow.com/questions/13932750/tinytext-text-mediumtext-and-longtext-maximum-storage-sizes

Answer 6

no error just don not recieve data
medium text

Answer 7

i made but no change ..
test , long text , blob , long blob , varchar
no change !!!
i think it is not about db
it is about encoding or server which i retrive data to