Enter special characters in data editor

[hkrackau]

Hello,
I want to enter a default value for a varchar(10) data type.
The default character shall be: '°'
It is denied as an invalid value.
When I try the same with mySQL Workbench it works fine.
Back in dbForge the character '°' is displayed as '°'.
How can I fix this? Any help is welcome.

Win 10-64 // dbForge Version 7.1.13

[alexa]

Please select 'utf8 -> Unicode (UTF-8)' on the 'Advanced' tab of the 'Database Connection Properties' dialog box that can be opened by right-clicking the connection in Database Explorer and selecting 'Modify Connection' from the popup menu.

Also, we would like to let you know that there is a newer version 7.2 of dbForge Studio for MySQL available for downloading https://www.devart.com/dbforge/mysql/st ... nload.html

[hkrackau]

Alexa,
that was the missing piece of information.
Thanks a lot.

[alexa]

Thank you for the reply.

Please let us know if any questions arise.