dbForge for MySql should default to utf8mb4 instead of utf8 to improve unicode support
utf8 in mysql is a proprietary 3-byte format and doesn't support real utf8 encodings with 4-byte chars. As result, when dealing with real unicode, many scripts generated by dbforge fail with "Incorrect string value: \xF..." because mysql cannot understand 4 byte strings.
The correct utf8 encoding in mysql is 'utf8mb4' and everywhere dbforge puts utf8 by default (generated scripts, default connection encodings, etc), it should put utf8mb4 to improve support.
Currently I have to save all scripts and change utf8 to utf8mb4 manually.
Natan Vivo
shared this idea
-
ivan
commented
да поправьте уже на utf8mb4, невозможно работать.
-
Natan Vivo
commented
utf8 in mysql is a proprietary 3-byte format and doesn't support real utf8 encodings with 4-byte chars. As result, when dealing with real unicode, many scripts generated by dbforge fail with "Incorrect string value: \xF..." because mysql cannot understand 4 byte strings.
The correct utf8 encoding in mysql is 'utf8mb4' and everywhere dbforge puts utf8 by default (generated scripts, default connection encodings, etc), it should put utf8mb4 to improve support.
Currently I have to save all scripts and change utf8 to utf8mb4 manually.