Visokio website     Downloads     Video tutorials     KnowledgeBase  
Export: changing character set in database output? - Visokio Forums
Export: changing character set in database output?
  • Alexander     Alexander January 2, 2015 5:35AM
    Hi all,

    First of all, the best wishes for 2015!

    We use a DataManager workflow that publishes data into a database table. Based on the situation, we adjust the publication setting (Insert, Update, etc). Special tokens like ü, ë and é are being saved incorrectly in the database.

    Therefore we would like to manually adjust the charset that Omniscope uses to publish database tables.

    Can you advise how this can be configured?
  • 4 Comments
  •     Veaceslav January 8, 2015 9:01AM
    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
  • Alexander     Alexander January 8, 2015 9:03AM
    Hi Slavvi,

    Thanks, We are using MySQL in combination with Omniscope 2.8 b1282.
  •     Veaceslav January 8, 2015 11:15AM
    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.
  • Alexander     Alexander January 9, 2015 3:51AM
    Hi Slavvi,

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

Welcome!

It looks like you're new here. If you want to get involved, click one of these buttons!

Sign In Apply for Membership