14,974
edits
Heterogeneity interpreter integration: Difference between revisions
Jump to navigation
Jump to search
m
Heterogeneity interpreter integration (edit)
Revision as of 19:14, 24 September 2025
, 24 September 2025no edit summary
mNo edit summary |
|||
| (One intermediate revision by the same user not shown) | |||
| Line 1: | Line 1: | ||
Considerations of multi-languages Interpreter integration | Considerations of multi-languages Interpreter integration e.g. PHP calling Python | ||
== PHP calling Python == | |||
Input / Output | Input / Output | ||
* ill-formed input and output | * ill-formed input and output | ||
| Line 22: | Line 23: | ||
** e.g. memory error caused by second interpreter | ** e.g. memory error caused by second interpreter | ||
* API level | * API level | ||
== PHP calling MySQL == | |||
Purpose | |||
* PHP to generate mysqldump command for database backup and export operations with Chinese character support | |||
Input / Output | |||
* Character encoding mismatch between PHP UTF-8 and MySQL client character sets | |||
* Hexadecimal representation<ref>[https://dev.mysql.com/doc/refman/8.4/en/hexadecimal-literals.html MySQL :: MySQL 8.4 Reference Manual :: 11.1.4 Hexadecimal Literals]</ref> required for Chinese characters: '範例中文字' → 0xE7AF84E4BE8BE4B8ADE69687E5AD97 | |||
* Export validation discrepancy: Expected xxx SQL queries | |||
Process | |||
* Character set validation before MySQL command execution | |||
* Environment synchronization: PHP, Windows CMD, and MySQL client charset alignment | |||
* Hexadecimal conversion for non-ASCII parameter bypass | |||
<pre> | |||
function toHexadecimal($text) { | |||
if (!mb_check_encoding($text, 'UTF-8')) { | |||
$text = mb_convert_encoding($text, 'UTF-8', 'auto'); | |||
} | |||
return '0x' . strtoupper(bin2hex($text)); | |||
} | |||
</pre> | |||
== References == | == References == | ||
| Line 36: | Line 61: | ||
* [https://errerrors.blogspot.com/2018/08/run-java-jar-from-php.html 如果透過 PHP 網站呼叫 Java JAR 執行結果] | * [https://errerrors.blogspot.com/2018/08/run-java-jar-from-php.html 如果透過 PHP 網站呼叫 Java JAR 執行結果] | ||
[[Category:Programming]] [[Category:PHP]] [[Category:Python]] | [[Category: Programming]] | ||
[[Category: PHP]] | |||
[[Category: Python]] | |||
[[Category: MySQL]] | |||
[[Category: Revised with LLMs]] | |||