Retrieving data in Paragraph from | Mysql | Phpmyadmin

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?

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.

And Taifun’s script ?

1 Like

Yes

https://puravidaapps.com/mysql.php

1 Like

Try this
It has two solutions check which one is working for you

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.