View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
0000580 | SymmetricDS | Improvement | public | 2012-01-01 20:53 | 2014-02-03 01:53 |
Reporter | Assigned To | chenson | |||
Priority | high | ||||
Status | closed | Resolution | fixed | ||
Product Version | 3.3.5 | ||||
Target Version | 3.4.0 | Fixed in Version | 3.4.0 | ||
Summary | 0000580: MySQL trigger throwing error on special characters | ||||
Description | Investigate whether the character set should be specified for mysql trigger variables See https://sourceforge.net/projects/symmetricds/forums/forum/739236/topic/4989336 It seems like in order to support unicode characters you need to add this to the JDBC URL: ?useUnicode=true&characterEncoding=utf8&characterSetResults=utf8 And declare your table's columns using: VARCHAR(XXX) CHARACTER SET utf8 And alter trigger variable to use `CHARACTER SET urf8` variables | ||||
Tags | No tags attached. | ||||
SymmetricDS: master 3e948ec3 2013-03-12 19:32:33 Details Diff |
0000580: MySQL trigger throwing error on special characters |
Affected Issues 0000580 |
|
mod - symmetric-client/src/main/java/org/jumpmind/symmetric/db/mysql/MySqlTriggerTemplate.java | Diff File | ||
SymmetricDS: master f5586b73 2013-03-12 19:36:02 Details Diff |
0000580: MySQL trigger throwing error on special characters |
Affected Issues 0000580 |
|
mod - symmetric-client/src/main/java/org/jumpmind/symmetric/db/mysql/MySqlTriggerTemplate.java | Diff File |
Date Modified | Username | Field | Change |
---|---|---|---|
2012-06-18 18:11 | admin | Target Version | 3.1.0 => |
2013-03-12 23:32 | chenson | Product Version | => 3.3.5 |
2013-03-12 23:32 | chenson | Fixed in Version | 3.1.0 => 3.4.0 |
2013-03-12 23:32 | chenson | Target Version | => 3.4.0 |
2013-03-12 23:32 | chenson | Status | new => resolved |
2013-03-12 23:32 | chenson | Resolution | open => fixed |
2013-03-12 23:32 | chenson | Assigned To | => chenson |
2013-04-21 16:22 | chenson | Status | resolved => closed |
2014-02-03 01:53 | Changeset attached | => SymmetricDS trunk r6946 | |
2014-02-03 01:53 | Changeset attached | => SymmetricDS trunk r6947 | |
2015-07-31 01:49 | chenson | Changeset attached | => SymmetricDS master f5586b73 |
2015-07-31 01:49 | chenson | Changeset attached | => SymmetricDS master 3e948ec3 |