Remove non breaking space: Difference between revisions
Jump to navigation
Jump to search
(Created page with "How to remove non breaking space == Definition == # [https://en.wikipedia.org/wiki/Non-breaking_space Non-breaking space] ({{kbd | key=<nowiki>nbsp;</nowiki>}}) Sentence s...") |
No edit summary |
||
| Line 1: | Line 1: | ||
How to remove non breaking space | How to display or remove non-breaking space | ||
== Definition == | == Definition == | ||
# [https://en.wikipedia.org/wiki/Non-breaking_space Non-breaking space] ({{kbd | key=<nowiki>nbsp;</nowiki>}}) | # [https://en.wikipedia.org/wiki/Non-breaking_space Non-breaking space] ([https://zh.wikipedia.org/zh-tw/%E4%B8%8D%E6%8D%A2%E8%A1%8C%E7%A9%BA%E6%A0%BC 不換行空格], {{kbd | key=<nowiki>nbsp;</nowiki>}}) | ||
Sentence spacing | Sentence spacing | ||
Revision as of 13:54, 3 May 2022
How to display or remove non-breaking space
Definition
- Non-breaking space (不換行空格, nbsp;)
Sentence spacing
- 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);[1]
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