Byte order mark: Difference between revisions
Jump to navigation
Jump to search
(Created page with "[https://en.wikipedia.org/wiki/Byte_order_mark Byte order mark] (BOM, [https://zh.wikipedia.org/wiki/%E4%BD%8D%E5%85%83%E7%B5%84%E9%A0%86%E5%BA%8F%E8%A8%98%E8%99%9F 位元組...") |
(No difference)
|
Revision as of 12:32, 23 April 2018
Byte order mark (BOM, 位元組順序記號)
How to see Byte order mark
MySQL way
Using MySQL HEX() function "returns a string representation of a hexadecimal value of a decimal or string value specified as an argument."
CREATE TABLE `articles` (
`id` varchar(50) NOT NULL,
`notes` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
INSERT INTO `articles` (`id`, `notes`) VALUES
('1234567890', 'no BOM'),
('1234567890', 'BOM');
ALTER TABLE `articles`
ADD UNIQUE KEY `id` (`id`) USING BTREE;
SELECT HEX(id), id, notes FROM articles;
| HEX(id) | id | notes |
|---|---|---|
| 31323334353637383930 | 1234567890 | no BOM |
| EFBBBF31323334353637383930 | 1234567890 | BOM |
File command way
Using file (command): file filename.txt on Linux 
, macOS 
[1] & Cygwin on Win 
| File content | Example result returned by file command |
|---|---|
| File contains BOM | UTF-8 Unicode (with BOM) text |
| File NOT contains BOM | UTF-8 Unicode text |