UTF 8 in MySQL

by Nov 3, 2018

We have a MySQL database which has been created with utf8 character set and unicode collation (CREATE DATABASE dbname DEFAULT CHARACTER SET utf8mb4 DEFAULT COLLATE utf8mb4_unicode_ci), and with table and column definitions also set to utf8.

If we try to insert utf8 data into the tables using Aqua Data Studio (18.0.19) then the data is not stored correctly, however it works if passing the same query using MySQL Workbench.

For example the following query using MySQL Workbench works but not using ADS, which will store the data as ‘??’

insert into dbname values (‘权益’)
We have tested using Workbench to insert and ADS to read, and vice versa.

We have also followed other help references to add ‘?characterEncoding=utf8’ to the Driver Parameters under Server Properties.

None of these changes seem to work.

Is there a configuration that needs to be set to properly handle UTF8 in Aqua Data Studio?


Thomas Conrad over 4 years ago
Hi Chris,

Do you have the Query Analyzer editor in Aqua Data Studio set to utf8? You can set that in the Query Analyzer window or in the Aqua Data Studio Options menu. File->Options->General->Editor Encoding. See the attached screenshots as an example.

Thanks, Tom

Chris King over 4 years ago in reply to Thomas Conrad
Hi Tom,

Yes the Editor is set to UTF8.


Thomas Conrad over 4 years ago in reply to Chris King
Hi Chris,

Did the example that I provided help? It looks like it worked.

Thanks, Tom