html前端数据写入mysql_HTML发布的表单数据以jibberish的形式写入MySQL数据库

最新推荐文章于 2023-03-27 11:30:27 发布

孤独凤凰战士

最新推荐文章于 2023-03-27 11:30:27 发布

阅读量311

点赞数

文章标签： html前端数据写入mysql

本文链接：https://blog.csdn.net/weixin_30510711/article/details/113348215

版权

在使用WSGI_mod时，由于默认编码为ASCII，导致包含希腊字符的HTML表单数据以乱码形式写入MySQL数据库。为解决此问题，需设置服务器环境变量为UTF-8或iso-8859-1，特别是当Apache从系统初始化脚本启动时，可能使用默认的ASCII编码。推荐设置LANG或LOCALE环境变量为en_US.UTF-8以确保正确解码。

摘要由CSDN通过智能技术生成

根据wsgi_mod文档，WSGIDaemonProcess的默认编码是ASCII。ASCII中不包括希腊字符，并且您的输入未正确解码。如果要允许使用希腊字符，则必须使用UTF-8或iso-8859-1。通常服务器是由init系统启动的deamons，99%的情况下仍然使用ASCII作为默认编码。在开发或调试时，通常不会遇到这些问题，因为python脚本继承了当前用户的环境，而当前用户通常使用UTF-8。在$env

.....

LANG=en_GB.UTF-8

.....

引用apache的wsgi_mod：lang=locale

Set the current language locale. This is the same as having set the LANG environment variable.

You will need to set this on many Linux systems where Apache when started up from system init scripts uses the default C locale, meaning that the default system encoding is ASCII. Unless you need a special language locale, set this to en_US.UTF-8.

Whether the lang or locale option works best can depend on the system being used. Set both if you aren’t sure which is appropriate.

locale=locale

Set the current language locale. This is the same as having set the LC_ALL environment variable.

Whether the lang or locale option works best can depend on the system being used. Set both if you aren’t sure which is appropriate.