Hi Alexander,

It depends on the type of database you have. SQL Server should properly handle these characters by default. MySQL may need to be configured manually. Unfortunately, changing the charset of a table is not currently supported in Omniscope. You will have to do it manually by executing specific database SQL queries.

If you want to help configuring your tables, please email us the database type and version you are using.

Thanks,

Slavvi

Hi Slavvi,

Thanks, We are using MySQL in combination with Omniscope 2.8 b1282.

MySQL uses utf8_general_ci by default which handles such characters properly.

Open your MySQL Workbench, connect to your server and check the default database collation. You can execute the following SQL queries:
use your_database_name;
show table status;

If your default collation cannot handle the characters you need, try to set it to utf8_general_ci

To change the default collation for the database execute:

alter database your_db_name COLLATE utf8_general_ci;

However, that will not change collation for existing tables. It will be used for the tables you will create from now on.

To alter collation of an existing table execute:

alter table your_table_name convert to character set utf8 collate utf8_general_ci;

Please note that you should not alter any collation if the one you have already supports the type of symbols you need, since you might have a different issue, and changing collation will not resolve it. If that's the case, please email us a list of steps with more details how to reproduce the issue. Also, please include the version of your MySQL server.

Hi Slavvi,

Thanks for the explenation, I will consult our IT specialist.