Devart Forums

Hello all,

I have to import an Excel File and in this file could be Cyrilic, Chinese or Japanese.
How do I have to set the "Charater Set" and "Collation" on server side and what do I have to set in TMyConnection and TMyQuery.

I'm using C++Builder 8.

Thanks for your help.
Thomas

To solve the problem you should use the TMyConnection.Options.Charset property.
You can find more detailed information about this option in the MyDAC help.

So I tried it.
I have a MySQL database with UTF-8 and I have MySQL Table with UTF-8.
I set the TMyConnection->Option->Charset = "utf8".
I tried to import the data with TQImport3Wizard from EMS and I also tried it with the components of www.scalabium.com.
Both without success. In both cases I see in the database "???" but no cyrillic character.

If I import the data with NaviCat everything is fine. And I cannot believe that both component provider are not able to handle UTF-8. Did I miss something with your component?
Do you have an example importing Excel into MySQL table with UTF-8?

Thanks Thomas

Please try to compose a small sample to demonstrate the problem and send it to dmitryg*devart*com.

Hi Dimon,

now I was able to import the data with TQImport3Wizard.
And the problem was, that setting of the Option in TMyConnection.
I set the Option TMyConnection->Option->Charset = "utf8" and this is not correct. I tried it with TMyConnection->Option->UseUnicode = true;

Thanks
Thomas

It is good to see that this problem has been solved.