View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0001646 | Database Workbench v5 | MySQL Module | public | 2018-10-09 11:30 | 2018-10-22 13:07 |
| Reporter | Stephen Lappin | Assigned To | Martijn Tonies | ||
| Priority | normal | Severity | minor | Reproducibility | always |
| Status | closed | Resolution | fixed | ||
| Product Version | 5.4.4 | ||||
| Fixed in Version | 5.4.6 | ||||
| Summary | 0001646: Support MySQL utf8mb4 character set in diagrams | ||||
| Description | MySQL/MariaDB’s “utf8” isn’t UTF-8. The “utf8” encoding only supports three bytes per character. The real UTF-8 encoding needs up to four bytes per character. MySQL developers never fixed this bug. They released a workaround in 2010: a new character set called “utf8mb4”. | ||||
| Additional Information | https://medium.com/@adamhooper/in-mysql-never-use-utf8-use-utf8mb4-11761243e434 | ||||
| Tags | No tags attached. | ||||
|
|
'utf8mb4' is listed when creating a database and in the 'Charset' drop down box in, eg, the Table Editor. not sure what you're expecting in addition to that? |
|
|
It is not listed inteh default characterset drop-down in Model Option in Physical Data Model diagram. Nor in Table properties. |
|
|
Ah, right, the non-connected version. I've added that charset for MySQL 5.5 and up. |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2018-10-09 11:30 | Stephen Lappin | New Issue | |
| 2018-10-09 17:50 | Martijn Tonies | Note Added: 0000486 | |
| 2018-10-09 17:50 | Martijn Tonies | Assigned To | => Martijn Tonies |
| 2018-10-09 17:50 | Martijn Tonies | Status | new => feedback |
| 2018-10-10 09:54 | Stephen Lappin | Note Added: 0000487 | |
| 2018-10-10 09:54 | Stephen Lappin | Status | feedback => assigned |
| 2018-10-10 10:09 | Martijn Tonies | Note Added: 0000488 | |
| 2018-10-10 10:09 | Martijn Tonies | Summary | Support MySQl utf8mb4 character set => Support MySQL utf8mb4 character set in diagrams |
| 2018-10-10 10:09 | Martijn Tonies | Status | assigned => resolved |
| 2018-10-10 10:09 | Martijn Tonies | Fixed in Version | => 5.4.6 |
| 2018-10-10 10:09 | Martijn Tonies | Resolution | open => fixed |
| 2018-10-22 13:07 | Martijn Tonies | Status | resolved => closed |
