Looking for good documentation on utf8/unicode

[JEFFB]

Hello,

I am trying to learn how to manage data in mysql that has special characters in the text. Currently I cannot insert special characters into a varchar. I have myconnection charset to utf8. I have a mysql table with two fields. The first is just a varchar(10) field charset set to latin1 and the second field is a varchar(200) charset to utf8. Get the ??? when the is sent to the testtable.

I am using Delphi 10 Seattle, I used mydac in the past and mysql 5.7.10.

I have been trying to understand and it seems very confusing. If someone can point me to a simple example and documentation. That would be great.

Thanks,

Jeff

[ViktorV]

To solve the problem try to set the TMyConnection.Options.UseUnicode property to "True" .
You can learn how to use these properties from the MyDAC help: https://www.devart.com/mydac/docs/?usin ... acters.htm