Data type: Difference between revisions
Jump to navigation
Jump to search
→雜湊碼 (hash value) e.g. MD5, SHA
m (→台灣公司統一編號) |
|||
| Line 111: | Line 111: | ||
* PHP: [http://php.net/manual/en/function.bin2hex.php bin2hex()] e.g. {{kbd | key=<nowiki>echo bin2hex(hex2bin(hash('sha256', 'The quick brown fox jumped over the lazy dog.')));</nowiki>}} | * PHP: [http://php.net/manual/en/function.bin2hex.php bin2hex()] e.g. {{kbd | key=<nowiki>echo bin2hex(hex2bin(hash('sha256', 'The quick brown fox jumped over the lazy dog.')));</nowiki>}} | ||
* MySQL: [https://dev.mysql.com/doc/refman/8.0/en/hexadecimal-literals.html Hexadecimal Literals] e.g. {{kbd | key=<nowiki>SELECT HEX(UNHEX(SHA2('The quick brown fox jumped over the lazy dog.', 256)));</nowiki>}}<ref>[https://stackoverflow.com/questions/14608413/storing-a-binary-sha1-hash-into-a-mysql-binary20-column insert - Storing a binary SHA1 hash into a mySQL BINARY(20) column - Stack Overflow]</ref> | * MySQL: [https://dev.mysql.com/doc/refman/8.0/en/hexadecimal-literals.html Hexadecimal Literals] e.g. {{kbd | key=<nowiki>SELECT HEX(UNHEX(SHA2('The quick brown fox jumped over the lazy dog.', 256)));</nowiki>}}<ref>[https://stackoverflow.com/questions/14608413/storing-a-binary-sha1-hash-into-a-mysql-binary20-column insert - Storing a binary SHA1 hash into a mySQL BINARY(20) column - Stack Overflow]</ref> | ||
== GUID 唯一辨識碼字串 == | |||
* BINARY(16)<ref>[https://stackoverflow.com/questions/412341/how-should-i-store-guid-in-mysql-tables How should I store GUID in MySQL tables? - Stack Overflow]</ref> | |||
* VARCHAR(36) or CHAR(36) | |||
=== Store the GUID value === | |||
<pre> | |||
SELECT UUID(); | |||
-- 4470beb9-ab1e-11ec-bd92-00155de8c33a | |||
INSERT INTO `sometable` | |||
(`guid_char`, `guid_binary`) | |||
VALUES ( | |||
'4470beb9-ab1e-11ec-bd92-00155de8c33a', | |||
UNHEX(REPLACE("4470beb9-ab1e-11ec-bd92-00155de8c33a", "-","")) | |||
); | |||
</pre> | |||
{{exclaim}} Need to replace the - symbol with whitespace from GUID value. Or it will not able to retrieve the GUID value | |||
==== Retrieve the GUID value ==== | |||
<pre> | |||
SELECT `guid_char`, HEX(`guid_binary`) | |||
FROM `sometable`; | |||
</pre> | |||
=== membership === | === membership === | ||