Re: [Dev] [DEV] [CEP] MySQL table storage engine and character set used with Output Mysql Event Adaptor

2016-05-27 Thread Thanuja Uruththirakodeeswaran
Hi , On Fri, May 27, 2016 at 1:11 AM, Lasantha Fernando wrote: > Hi Thanuja, > > Were you able to resolve the issue after changing the charset and engine? > Also can you specify the MySQL connector version that you were using? > Yes, It worked with MyISAM and utf-8.

Re: [Dev] [DEV] [CEP] MySQL table storage engine and character set used with Output Mysql Event Adaptor

2016-05-26 Thread Lasantha Fernando
Hi Thanuja, Were you able to resolve the issue after changing the charset and engine? Also can you specify the MySQL connector version that you were using? @Mohan, we did a debug session and what we could observe was that the encoding was set to windows-1252 as I remember. The main issue here

Re: [Dev] [DEV] [CEP] MySQL table storage engine and character set used with Output Mysql Event Adaptor

2016-05-26 Thread Mohanadarshan Vivekanandalingam
On Fri, May 27, 2016 at 12:17 AM, Thanuja Uruththirakodeeswaran < thanu...@wso2.com> wrote: > Hi , > > Do we need to set the MySQL *storage engine* as '*MyISAM*' and *character > set *to* utf8* for the tables created by the CEP Output MySQL Event > Adaptors? > > I'm using CEP 3.0.0/3.1.0 with

[Dev] [DEV] [CEP] MySQL table storage engine and character set used with Output Mysql Event Adaptor

2016-05-26 Thread Thanuja Uruththirakodeeswaran
Hi , Do we need to set the MySQL *storage engine* as '*MyISAM*' and *character set *to* utf8* for the tables created by the CEP Output MySQL Event Adaptors? I'm using CEP 3.0.0/3.1.0 with MySQL server version *5.6.30*. If I don't set those, by default storage engine is set to *InnoDB* and