Home:ALL Converter>Export hidden characters from MySQL-Database

Export hidden characters from MySQL-Database

Ask Time:2017-04-05T14:52:15         Author:alti4

Json Formatter

I have a MySQL-Database (data from OTRS) and a PHP-script that reads data from this database and emails this data to a specific address. That actually works.

My problem is, that the stored data has "hidden" characters like linebreaks etc. that are just exported as "blank" and not as new line.

How does MySQL store this data and how to make it appear in a normal "echo"-command in PHP?

Author:alti4,eproduced under the CC 4.0 BY-SA copyright license with a link to the original source and this disclaimer.
Link to original article:https://stackoverflow.com/questions/43223845/export-hidden-characters-from-mysql-database
yy