none
PowerBi and mysql RRS feed

  • Question

  • Have a good day.

    I have query form PowerBi to mysql database. 

    When the query is simple - everything is ok - the result in correct encoding and not empty.

    Mysql have collation utf8_general_ci

    data - varchar with cyrillic text

    When I try to use some cyrillic text in query - I have no error but empty result. 

    When I make  same query in phpMyAdmin - the result table not blank.

    I've try to use SET NAMES 'utf-8' but it is not working for me.

    Thanks for advices.

    Tuesday, July 2, 2019 10:47 AM

Answers


  • I've solve my issue by setup default charset in mysql server side.

    For this I've setup VM, run mysql_update and configure server coresponding the article above. Now everything is ok.

    [client]
    default-character-set=utf8
    
    [mysql]
    default-character-set=utf8
    
    
    [mysqld]
    collation-server = utf8_unicode_ci
    init-connect='SET NAMES utf8'
    character-set-server = utf8

    from stackoverflow

    Thursday, July 4, 2019 9:51 AM