Qlik Community

Ask a Question

Qlik Replicate

Discussion board for collaboration on Qlik Replicate.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources. Prep for the big move: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Clever_Anjos
Employee
Employee

MySQL Community as a Source

I'm trying to load data from a MySQL Community (Server version: 8.0.19 MySQL Community Server - GPL) installed in same machine that Replicate 6.5

my.ini
default-storage-engine=INNODB
log-bin="SENSE-bin"
binlog_format=row
binlog_checksum=NONE

When I try to create a task using this MySQL as a source, I'm getting this error:

Stream component 'st_0_MySQL' terminated
Cannot initialize subtask
Failed while preparing stream component 'st_0_MySQL'.
Errors in MySQL server binary logging configuration
Error 2019 (Can't initialize character set unknown (path: compiled_in)) connecting to MySQL server 'localhost'

Can anyone point me one direction to check what can be done to solve this?

 

 

1 Solution

Accepted Solutions
Clever_Anjos
Employee
Employee
Author

Solved 

file path: %PROGRAMDATA%\MySQL\MySQL Server X.X\my.ini

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

[client]
default-character-set = utf8

[mysql]
default-character-set = utf8

View solution in original post

2 Replies
Clever_Anjos
Employee
Employee
Author

Solved 

file path: %PROGRAMDATA%\MySQL\MySQL Server X.X\my.ini

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

[client]
default-character-set = utf8

[mysql]
default-character-set = utf8

View solution in original post

john_wang
Support
Support

MySQL default character set changed from UTF8 to UTF8MB4. Qlik Replicate does not support this character set yet.
You can change the character set to UTF8 as a WA.

thanks,

John.