Charset

Discussion of open issues, suggestions and bugs regarding MyDAC (Data Access Components for MySQL) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
vallemanden
Posts: 19
Joined: Sat 11 Jun 2011 07:44

Charset

Post by vallemanden » Tue 20 Oct 2015 11:43

Hi there,

Is there a way to read the charset on the database?

kind regards
Vallemanden

ViktorV
Devart Team
Posts: 3168
Joined: Wed 30 Jul 2014 07:16

Re: Charset

Post by ViktorV » Thu 22 Oct 2015 12:52

You can query system tables of MySQL server using the TMyQuery component. For example:

Code: Select all

MyQuery.SQL.Text := 'SELECT  default_character_set_name FROM information_schema.SCHEMATA where SCHEMA_NAME = "DatabaseName"';

vallemanden
Posts: 19
Joined: Sat 11 Jun 2011 07:44

Re: Charset

Post by vallemanden » Thu 22 Oct 2015 21:04

Thank you alot

ViktorV
Devart Team
Posts: 3168
Joined: Wed 30 Jul 2014 07:16

Re: Charset

Post by ViktorV » Mon 26 Oct 2015 16:27

If you have any questions during using our products, please don't hesitate to contact us - and we will try to help you solve them.

Post Reply