Hi, I’ve stored a paragraph (with commas and spaces) in a column(datatype: longtext) in phpmyadmin.
When I retrieve it from database and try to show it in label it just shows few words.
When I remove commas and spaces, it works fine.
But I want data with commas.
Is there any way to resolve this?
Taifun
July 31, 2020, 8:05pm
#2
which solution are you using to access the MySQL database? you might want to modify your php script…
what you always can do is to replace the commas by another symbol (for example @@@) in the database and after downloading use the replace all block to replace @@@ by ,
Taifun
3 Likes
I’m accessing database with web component in kodular.
Try this
It has two solutions check which one is working for you
No no his problem is whenever he tries to save a text of length of more than one words he is unable to get them in his specific index instead the retured text get mixed or something like this
But when he tries to save only one word it works
Actually this problem is very odd but i also have faced this one and it can only be solved by two methods
method 1
Use text encoding and decoding
(m using thiz and it works fine and text encryption is also recommended if u want to save your data)
Metho…
system
(system)
Closed
August 31, 2020, 4:19am
#7
This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.