0
how to show more than 1900 char from Mysql db
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
7 Answers
+ 3
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 ...
+ 1
What error are you getting? Is the field type "TEXT"?
+ 1
Can you change it to TEXT?
+ 1
Or maybe LONGTEXT
0
no error just don not recieve data
medium text
0
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