gui自动递增，外键更改，数据类型上的MySQL Workbench错误 [英] Mysql Workbench bugs on gui auto increment, foreign key changing, datatype

问题描述

我正在使用MySQL Workbench版本6.1(6.1.4.11773内部版本1454).我在Workbench中也看到错误.但是仅在使用gui时存在问题.没有错误或代码问题，请手动查询.我无法使用alter table的复选框更改自动增量.但是我可以更改代码.没有代码我无法设置外键.设置外键引用列存在复选框问题.但是我可以用代码设置相同的外键.当我将数据类型设置为"INT(11)"时，它正在工作，但是随后它显示为(11)".我看到很多类似的东西.这些是错误吗?

I'm working on MySQL Workbench Version 6.1 (6.1.4.11773 build 1454). I see too bugs in Workbench. But there are issue only on using gui. There are no bug or issue with codes, query so manually. I cant change auto increment with checkbox of alter table. But i can change with codes. I can't set foreign key without codes. There is a checkbox issue of setting foreign key referenced column. But I can set same foreign key with codes. And When I set a Datatype look like "INT(11)", It's working but then It's looking this "(11)". I see a lot of thing like these. Are these bugs?

推荐答案

如果在土耳其语区域设置中运行mysql workbench，它将无法正常工作.用"INT"字段创建一个表.然后保存.然后尝试更改表格.它只会显示(11)作为字段类型.因为在土耳其语区域中，我和我是不同的字母. (对应于ı和İ)，这在尝试创建外键时会导致问题.因为它找不到类型(11)的任何列.

if you run mysql workbench in Turkish locale, it will not work correctly. Create a table with "INT" fields. Then save it. then try to alter the table. it will only display (11) as the field type. Because in Turkish locale, i and I are different letters. (corresponding to ı and İ) and this causes a problems while trying to create foreign keys. because it cannot find any columns with type (11).

转到您的服务器->选项文件，并将这些选项更改为

Go to your Server->Options File and change these options to

1. 字符服务器文件=> utf8
2. 整理服务器=> utf8_general_ci

对我有用.

这篇关于gui自动递增，外键更改，数据类型上的MySQL Workbench错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！