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

10th Dec 2018, 4:05 AM
Ahmed ik
Ahmed ik - avatar
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 ...
11th Dec 2018, 3:11 AM
Ipang
+ 1
What error are you getting? Is the field type "TEXT"?
10th Dec 2018, 9:30 PM
Jon Jackson
Jon Jackson - avatar
+ 1
Can you change it to TEXT?
10th Dec 2018, 9:31 PM
Jon Jackson
Jon Jackson - avatar
+ 1
Or maybe LONGTEXT
10th Dec 2018, 9:32 PM
Jon Jackson
Jon Jackson - avatar
0
no error just don not recieve data medium text
10th Dec 2018, 9:31 PM
Ahmed ik
Ahmed ik - avatar
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
10th Dec 2018, 9:37 PM
Ahmed ik
Ahmed ik - avatar