Data type - Revision history

Planetoid: /* 台灣公司統一編號 */

2025-11-04T07:49:06Z

台灣公司統一編號

← Older revision		Revision as of 15:49, 4 November 2025
Line 224:		Line 224:

	=== 台灣公司統一編號 ===		=== 台灣公司統一編號 ===
			統一編號 (Unified Business Number, 簡稱 UBN)

	* 數值長度：八位數字		* 數值長度：八位數字
	* 建議資料類型：因為可能以 0 開頭，所以建議使用 {{kbd \| key= CHAR(8)}}，而不建議使用 {{kbd \| key= INT(8)}} <ref>[https://www.etax.nat.gov.tw/etwmain/web/ETW113W1_1 公示資料查詢服務-財政部稅務入口網]</ref><ref>[http://herolin.webhop.me/entry/is-valid-TW-company-ID/ » 營利事業統一編號驗證完全手冊(Javascript,Java,C#,PHP) - Hero Think~用手摀住我的嘴]</ref> {{exclaim}} 早期公司統一編號不是八位數字		* 建議資料類型：因為可能以 0 開頭，所以建議使用 {{kbd \| key= CHAR(8)}}，而不建議使用 {{kbd \| key= INT(8)}} <ref>[https://www.etax.nat.gov.tw/etwmain/web/ETW113W1_1 公示資料查詢服務-財政部稅務入口網]</ref><ref>[http://herolin.webhop.me/entry/is-valid-TW-company-ID/ » 營利事業統一編號驗證完全手冊(Javascript,Java,C#,PHP) - Hero Think~用手摀住我的嘴]</ref> {{exclaim}} 早期公司統一編號不是八位數字

Planetoid: /* 網址 */

2025-10-19T14:17:20Z

網址

← Older revision		Revision as of 22:17, 19 October 2025
Line 32:		Line 32:
	參考資料		參考資料
	* [http://support.microsoft.com/kb/208427 最大 URL 長度是在 Internet Explorer 中的 2,083 字元] for {{IE}}<ref>[http://stackoverflow.com/questions/417142/what-is-the-maximum-length-of-a-url-in-different-browsers http - What is the maximum length of a URL in different browsers? - Stack Overflow]</ref><ref>[http://wiert.me/2010/04/20/maximum-url-lengths/ Maximum URL lengths « The Wiert Corner – irregular stream of stuff]</ref>		* [http://support.microsoft.com/kb/208427 最大 URL 長度是在 Internet Explorer 中的 2,083 字元] for {{IE}}<ref>[http://stackoverflow.com/questions/417142/what-is-the-maximum-length-of-a-url-in-different-browsers http - What is the maximum length of a URL in different browsers? - Stack Overflow]</ref><ref>[http://wiert.me/2010/04/20/maximum-url-lengths/ Maximum URL lengths « The Wiert Corner – irregular stream of stuff]</ref>

			=== Email ===
			* data type:
			** MySQL: {{kbd \| key=VARCHAR(254)}}<ref>[https://www.rfc-editor.org/rfc/rfc5321 RFC 5321: Simple Mail Transfer Protocol]"4.5.3.1.3. Path The maximum total length of a reverse-path or forward-path is 256 octets (including the punctuation and element separators)." Complete address in SMTP envelope (including {{kbd \| key=<nowiki><...></nowiki>}})</ref>
			* 遵循 [https://www.rfc-editor.org/rfc/rfc5321 RFC 5321: Simple Mail Transfer Protocol] 規格

	=== 姓名欄位 ===		=== 姓名欄位 ===

Planetoid: /* 雜湊碼 (hash value) e.g. MD5, SHA */

2025-03-05T07:40:12Z

雜湊碼 (hash value) e.g. MD5, SHA

← Older revision		Revision as of 15:40, 5 March 2025
Line 137:		Line 137:

	Explain the conversion process from 224 bits to 56 characters for SHA-224's output. Conversion process:		Explain the conversion process from 224 bits to 56 characters for SHA-224's output. Conversion process:
	* "Original output: 224 bits"		* Original output: 224 bits
	* Every 4 bits converts to 1 hexadecimal character (hex character): 224 ÷ 4 = 56		* '''Text Representation (Hexadecimal)''': Every 4 bits converts to 1 hexadecimal character (hex character): 224 ÷ 4 = 56 Therefore, it requires 56 hexadecimal characters to represent
	* Therefore, it requires 56 hexadecimal characters to represent		* '''Binary Storage Representation''': Every 8 bits equals 1 byte in binary storage: 224 ÷ 8 = 28 Therefore, it requires 28 bytes (binary(28)) to store efficiently


	[https://zh.wikipedia.org/wiki/MD5 MD5]: {{exclaim}} Not recommended to use this function to secure passwords		[https://zh.wikipedia.org/wiki/MD5 MD5]: {{exclaim}} Not recommended to use this function to secure passwords

Planetoid: /* 雜湊碼 (hash value) e.g. MD5, SHA */

2025-03-05T03:50:03Z

雜湊碼 (hash value) e.g. MD5, SHA

← Older revision		Revision as of 11:50, 5 March 2025
Line 83:		Line 83:
	'''Hash Algorithm Output and Schema Reference'''		'''Hash Algorithm Output and Schema Reference'''
	<ref>[https://en.wikipedia.org/wiki/Secure_Hash_Algorithms Secure Hash Algorithms - Wikipedia]</ref>		<ref>[https://en.wikipedia.org/wiki/Secure_Hash_Algorithms Secure Hash Algorithms - Wikipedia]</ref>
	<table border="1" class="wikitable sortable">
	<tr>		<table border="1" class="wikitable sortable" style="border-collapse: collapse; width: 100%;">
	<th>Algorithm</th>		<tr style="background-color: #f2f2f2;">
	<th>Output Size (bits)</th>		<th style="text-align: left;">Algorithm</th>
	<th>Max Length (chars)</th>		<th style="text-align: left;">Output Size (bits)</th>
	<th>Schema Recommendation</th>		<th style="text-align: left;">Max Length (chars)</th>
			<th style="text-align: left;">Schema Recommendation (Text)</th>
			<th style="text-align: left;">Schema Recommendation (Binary)</th>
	</tr>		</tr>
	<tr>		<tr>
Line 95:		Line 97:
	<td>32</td>		<td>32</td>
	<td>char(32)</td>		<td>char(32)</td>
			<td>binary(16)</td>
	</tr>		</tr>
	<tr>		<tr>
Line 101:		Line 104:
	<td>40</td>		<td>40</td>
	<td>char(40)</td>		<td>char(40)</td>
			<td>binary(20)</td>
	</tr>		</tr>
	<tr>		<tr>
Line 107:		Line 111:
	<td>56</td>		<td>56</td>
	<td>char(56)</td>		<td>char(56)</td>
			<td>binary(28)</td>
	</tr>		</tr>
	<tr>		<tr>
Line 113:		Line 118:
	<td>64</td>		<td>64</td>
	<td>char(64)</td>		<td>char(64)</td>
			<td>binary(32)</td>
	</tr>		</tr>
	<tr>		<tr>
Line 119:		Line 125:
	<td>96</td>		<td>96</td>
	<td>char(96)</td>		<td>char(96)</td>
			<td>binary(48)</td>
	</tr>		</tr>
	<tr>		<tr>
Line 125:		Line 132:
	<td>128</td>		<td>128</td>
	<td>char(128)</td>		<td>char(128)</td>
			<td>binary(64)</td>
	</tr>		</tr>
	</table>		</table>

Planetoid: /* GUID 全域唯一識別碼字串 */

2025-02-24T05:40:08Z

GUID 全域唯一識別碼字串

← Older revision		Revision as of 13:40, 24 February 2025
Line 181:		Line 181:
	* 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~~ 全域唯一識別碼字串 ===		=== UUID 通用唯一辨識碼、GUID 全域唯一識別碼字串 ===
	[https://zh.wikipedia.org/zh-tw/%E5%85%A8%E5%B1%80%E5%94%AF%E4%B8%80%E6%A0%87%E8%AF%86%E7%AC%A6 全域唯一識別碼 - 維基百科，自由的百科全書]		[https://zh.wikipedia.org/zh-tw/%E9%80%9A%E7%94%A8%E5%94%AF%E4%B8%80%E8%AF%86%E5%88%AB%E7%A0%81 通用唯一辨識碼 - 維基百科，自由的百科全書]、[https://zh.wikipedia.org/zh-tw/%E5%85%A8%E5%B1%80%E5%94%AF%E4%B8%80%E6%A0%87%E8%AF%86%E7%AC%A6 全域唯一識別碼 - 維基百科，自由的百科全書]
	* 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>		* 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)		* VARCHAR(36) or CHAR(36)

Planetoid: /* References */

2025-01-06T06:02:09Z

References

← Older revision		Revision as of 14:02, 6 January 2025
Line 293:		Line 293:


	[[Category:Web_Dev]] [[Category:Database]] [[Category:MySQL]] [[Category:Data Science]]		[[Category: Web_Dev]]
			[[Category: Database]]
			[[Category: MySQL]]
			[[Category: Data Science]]
			[[Category: Revised with LLMs]]

Planetoid: /* 雜湊碼 (hash value) e.g. MD5, SHA */ Hash Algorithm Output and Schema Reference

2025-01-06T06:01:26Z

雜湊碼 (hash value) e.g. MD5, SHA: Hash Algorithm Output and Schema Reference

@@ Line 80: / Line 80: @@
 === 雜湊碼 (hash value) e.g. MD5, SHA ===
 [https://zh.wikipedia.org/wiki/MD5 MD5]: {{exclaim}} Not recommended to use this function to secure passwords
 * Data type: CHAR(32) or VARCHAR(32)<ref>[https://stackoverflow.com/questions/14922208/can-i-use-varchar32-for-md5-values php - Can I use VARCHAR(32) for md5() values? - Stack Overflow]</ref>

Planetoid: /* 雜湊碼 (hash value) e.g. MD5, SHA */

2024-05-06T08:34:48Z

雜湊碼 (hash value) e.g. MD5, SHA

← Older revision		Revision as of 16:34, 6 May 2024
Line 89:		Line 89:

	[https://zh.wikipedia.org/zh-tw/SHA-1 SHA-1] (Secure Hash Algorithm 1) {{exclaim}} Not recommended to use this function to secure passwords		[https://zh.wikipedia.org/zh-tw/SHA-1 SHA-1] (Secure Hash Algorithm 1) {{exclaim}} Not recommended to use this function to secure passwords
	* Data type: CHAR(40)		* Data type:
			** CHAR(40) - The hexadecimal representation of a SHA-1 hash consists of 40 characters. SHA-1 is a 160-bit hash function, resulting in 160 binary bits. Since each hexadecimal character corresponds to 4 binary bits, 40 hexadecimal characters are needed to represent a complete SHA-1 hash.
			** BINARY(20) - If stored in binary format, a SHA-1 hash has a length of 20 bytes. Each byte contains 8 binary bits. Therefore, the BINARY(20) data type is used to store the binary representation of a SHA-1 hash.
	* Framework: MySQL [https://www.w3resource.com/mysql/encryption-and-compression-functions/sha1().php SHA1() function], [https://www.php.net/manual/en/function.sha1.php PHP: sha1 - Manual]		* Framework: MySQL [https://www.w3resource.com/mysql/encryption-and-compression-functions/sha1().php SHA1() function], [https://www.php.net/manual/en/function.sha1.php PHP: sha1 - Manual]

Planetoid: /* 雜湊碼 (hash value) e.g. MD5, SHA */

2024-05-06T08:33:37Z

雜湊碼 (hash value) e.g. MD5, SHA

← Older revision		Revision as of 16:33, 6 May 2024
Line 93:		Line 93:

	SHA-256 ([https://zh.wikipedia.org/zh-tw/SHA-2 SHA-2])		SHA-256 ([https://zh.wikipedia.org/zh-tw/SHA-2 SHA-2])
	* Data type: CHAR(64)		* Data type:
			** CHAR(64)　- The hexadecimal representation of a SHA-256 hash consists of 64 characters. This is because SHA-256 is a 256-bit hash function, resulting in 256 binary bits. Since each hexadecimal character corresponds to 4 binary bits, 64 hexadecimal characters are needed to represent a complete SHA-256 hash.
			** BINARY(32) - If stored in binary format, a SHA-256 hash has a length of 32 bytes. Each byte contains 8 binary bits. Therefore, the BINARY(32) data type is used to store the binary representation of a SHA-256 hash.
	* Framework: MySQL [https://dev.mysql.com/doc/refman/8.0/en/sha256-pluggable-authentication.html MySQL :: MySQL 8.0 Reference Manual :: 8.4.1.3 SHA-256 Pluggable Authentication], [https://www.php.net/manual/zh/function.hash.php PHP: hash - Manual]		* Framework: MySQL [https://dev.mysql.com/doc/refman/8.0/en/sha256-pluggable-authentication.html MySQL :: MySQL 8.0 Reference Manual :: 8.4.1.3 SHA-256 Pluggable Authentication], [https://www.php.net/manual/zh/function.hash.php PHP: hash - Manual]

Planetoid: /* 雜湊碼 (hash value) e.g. MD5, SHA */

2024-05-06T08:25:58Z

雜湊碼 (hash value) e.g. MD5, SHA

← Older revision		Revision as of 16:25, 6 May 2024
Line 82:		Line 82:
	[https://zh.wikipedia.org/wiki/MD5 MD5]: {{exclaim}} Not recommended to use this function to secure passwords		[https://zh.wikipedia.org/wiki/MD5 MD5]: {{exclaim}} Not recommended to use this function to secure passwords
	* Data type: CHAR(32) or VARCHAR(32)<ref>[https://stackoverflow.com/questions/14922208/can-i-use-varchar32-for-md5-values php - Can I use VARCHAR(32) for md5() values? - Stack Overflow]</ref>		* Data type: CHAR(32) or VARCHAR(32)<ref>[https://stackoverflow.com/questions/14922208/can-i-use-varchar32-for-md5-values php - Can I use VARCHAR(32) for md5() values? - Stack Overflow]</ref>
	* Framework: [https://www.php.net/manual/en/function.md5.php PHP: md5 - Manual]		* Framework: MySQL [https://www.w3resource.com/mysql/encryption-and-compression-functions/md5().php md5()], [https://www.php.net/manual/en/function.md5.php PHP: md5 - Manual]

	[https://zh.wikipedia.org/wiki/SHA%E5%AE%B6%E6%97%8F SHA]<ref>[https://stackoverflow.com/questions/2240973/how-long-is-the-sha256-hash mysql - How long is the SHA256 hash? - Stack Overflow]</ref><ref>[http://fishjerky.blogspot.com/2013/06/md5sha512.html 魚乾的筆記本: MD5被破解了，要改用SHA]</ref>:		[https://zh.wikipedia.org/wiki/SHA%E5%AE%B6%E6%97%8F SHA]<ref>[https://stackoverflow.com/questions/2240973/how-long-is-the-sha256-hash mysql - How long is the SHA256 hash? - Stack Overflow]</ref><ref>[http://fishjerky.blogspot.com/2013/06/md5sha512.html 魚乾的筆記本: MD5被破解了，要改用SHA]</ref>:
Line 91:		Line 91:
	* Data type: CHAR(40)		* Data type: CHAR(40)
	* Framework: MySQL [https://www.w3resource.com/mysql/encryption-and-compression-functions/sha1().php SHA1() function], [https://www.php.net/manual/en/function.sha1.php PHP: sha1 - Manual]		* Framework: MySQL [https://www.w3resource.com/mysql/encryption-and-compression-functions/sha1().php SHA1() function], [https://www.php.net/manual/en/function.sha1.php PHP: sha1 - Manual]

			SHA-256 ([https://zh.wikipedia.org/zh-tw/SHA-2 SHA-2])
			* Data type: CHAR(64)
			* Framework: MySQL [https://dev.mysql.com/doc/refman/8.0/en/sha256-pluggable-authentication.html MySQL :: MySQL 8.0 Reference Manual :: 8.4.1.3 SHA-256 Pluggable Authentication], [https://www.php.net/manual/zh/function.hash.php PHP: hash - Manual]


	==== Retrieve the hash value from string or file content ====		==== Retrieve the hash value from string or file content ====