New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Mycat-1.6.7.5连接到mysql8 建立表，发现表名，字段名全为大写 #2953

Open

XiaoYi-sit opened this issue Jun 27, 2024 · 2 comments

Labels

XiaoYi-sit commented Jun 27, 2024

Mycat中执行source /path/xxx.sql 导入数据，发现在MySQL中表名和字段名全部转为了大写，而sql文件中都是小写的。在网上也找了一些方法，比如在my.cnf中添加lower_case_table_names=1（表名和字段名不区分大小写，存储为小写）该参数在真实业务环境中行不通，如果某些表和字段就是要求为大写，该参数岂不是也存储为小写了。目前还没有找到处理的方法

XiaoYi-sit added the help wanted label

Author

XiaoYi-sit commented Jun 27, 2024

Author

XiaoYi-sit commented Jun 27, 2024

希望得到大佬的指导

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment