How to Replace hidden white space Character in Mysql

Asked Jan 15 '19 at 04:36

Active Jan 15 '19 at 05:38

Viewed 621 times

I Have to replace the hidden white space character in ' 331431'.
The hidden white space character in this string was '\u00A0'.
How to replace this character with mysql?

I have tried the usual replace mysql function to replace this, didn't work for me.

SELECT REPLACE(' 331431','\u00A0','');

The Output for the above Query is ' 331431'.

edited Jan 15 '19 at 05:38

Til

5,150
13
26
34

asked Jan 15 '19 at 04:36

Ajith Ath

Possible duplicate of [MySQL unicode literals](https://stackoverflow.com/questions/3632410/mysql-unicode-literals) – Amadan Jan 15 '19 at 04:43
Try `SELECT REPLACE(' 331431', x'C2A0', '');` – Amadan Jan 15 '19 at 04:47
How did you know that the hidden character is `\u00A0`? – Vijunav Vastivch Jan 15 '19 at 05:37
thank you for your response, I have checked from the following website https://www.soscisurvey.de/tools/view-chars.php – Ajith Ath Jan 15 '19 at 06:12

How to Replace hidden white space Character in Mysql

0 Answers0