Remove non breaking space

How to display or remove non-breaking space

Definition

1. Non-breaking space (不換行空格, nbsp;)

Sentence spacing

1. Sentence spacing in digital media - Wikipedia e.g. &Nbsp; &Ensp; &Emsp;

How to remove the non-breaking space In PHP

Replace Non-breaking space with one whitespace using PHP

$result = str_replace("\xc2\xa0", ' ', $original_string);

How to display the non-breaking space In PHP

$input = '12345678' . hex2bin('c2a0');
echo $input . PHP_EOL;
## Result of above script: '12345678 ' (one whitespace at the end)

echo bin2hex($input) . PHP_EOL;
## Result of above script: 3132333435363738c2a0

echo bin2hex('12345678') . PHP_EOL;
## Result of above script: 3132333435363738 (You mat notice the difference of script result is C2A0)

How to remove the non-breaking space In MySQL

SELECT REPLACE(`my_column`, UNHEX('C2A0'), '')
FROM `my_table`

How to display the non-breaking space In MySQL

SELECT CONCAT('12345678', UNHEX('C2A0'))
-- Result of above query: '12345678 ' (one whitespace at the end)

SELECT HEX(CONCAT('12345678', UNHEX('C2A0')))
-- Result of above query: 3132333435363738C2A0

SELECT HEX('12345678')
-- Result of above query: 3132333435363738 (You mat notice the difference of query result is C2A0)

SELECT LENGTH('12345678')
-- Result of above query: 8

SELECT LENGTH(CONCAT('12345678', UNHEX('C2A0')))
-- Result of above query: 10