Comments (8)
好的。我复制过来的,执行没问题,我模拟下加入ASCII字符,进行测试,并修正下,谢谢。如果有使用上的问题,请反馈,谢谢。如果有好的思路或者方法,也请反馈给我,感谢。
from goinsight.
解決辦法:
# 80端口為外部端口,可自行更改
# 8000為docker內部服務端口,8000端口不可改變
docker run -itd -p 80:8000 -e PYTHONIOENCODING=utf-8 -e LC_ALL='en_US.UTF-8' --name=sqlaudit 0a2b9265372d /bin/bash
或是 Dockfile 加上
ENV PYTHONIOENCODING=utf-8 LC_ALL en_US.UTF-8
from goinsight.
from goinsight.
from goinsight.
出錯語法:
ALTER TABLE `hotel` ADD COLUMN `en_name` varchar(255) NOT NULL DEFAULT '' COMMENT '飯店英文名稱' AFTER `name`
from goinsight.
您好,我这边测试是OK的,请问题你数据库的字符集是utf8?或者你输入的ALTER语句包含了ASCII字符,谢谢。
from goinsight.
是的,資料庫字符集是utf8,語法就是只上面這樣
ALTER TABLE `hotel` ADD COLUMN `en_name` varchar(255) NOT NULL DEFAULT '' COMMENT '飯店英文名稱' AFTER `name`
from goinsight.
你是加了:-e PYTHONIOENCODING=utf-8 这个解决的吗?
from goinsight.
Related Issues (20)
- ModuleNotFoundError: No module named 'celery.apps' HOT 7
- You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LIMIT 100' at line 58 HOT 1
- 本地dev环境配置 HOT 1
- test
- python manage.py migrate建表结构报错 HOT 3
- 提交导出工单的文件在那里?
- 语法检查报“语法检查失败,错误码:413” HOT 1
- MySQL5.7.8 版本以下不支持 MAX_EXECUTION_TIME设置 HOT 2
- 优化memory相关metrics名字 HOT 3
- 初始化SQL错误
- 前台页面无法打开,一直在转圈圈 HOT 1
- 请问这个可以用windows的pycharm开发工具运行吗? HOT 2
- 您好,请问为啥我这边没有权限管理,用户管理,数据库管理啥的呢?
- 开发者,您好,可以支持一下postgresql吗? HOT 2
- 后端安装Twisted的时候出错
- 可以支持英文吗? HOT 1
- 咨询:能否修改项目开源协议? HOT 2
- 【不影响使用】bootstrap.css和ant design vue的样式冲突导致icon移位 HOT 1
- 请问,是否需要帮忙实现接口 e2e 测试 HOT 3
- 能不能告知一下怎么配置 config.yaml文件?
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from goinsight.