View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0004401 | SymmetricDS | Bug | public | 2020-05-15 14:11 | 2020-06-04 17:55 |
| Reporter | elong | Assigned To | elong | ||
| Priority | normal | ||||
| Status | closed | Resolution | fixed | ||
| Product Version | 3.12.0 | ||||
| Target Version | 3.12.0 | Fixed in Version | 3.12.0 | ||
| Summary | 0004401: Oracle ntype characters lost from conversion in capture | ||||
| Description | When Oracle ntypes parameter is enabled and using different character sets in CHAR and NCHAR fields, the capture of changes causes casting to CHAR and loses characters for ntype fields. It seems like the use of decode() in the trigger template is causing a cast to CHAR, and we should try using nvl2() instead to preserve the original data type. | ||||
| Steps To Reproduce | Oracle database with these NLS settings: NLS_CHARACTERSET WE8ISO8859P1 NLS_NCHAR_CHARACTERSET AL16UTF16 CHAR fields can contain characters contained within the Latin-1 charset and NCHAR fields can contain characters within the UTF-8 charset. For NCHAR field with value: عاقل البخاري It gets captured in SYM_DATA as ¿¿¿¿ ¿¿¿¿¿¿¿¿ even though row_data is defined as an NLCOB field. | ||||
| Tags | character encoding, dialect: oracle | ||||
|
SymmetricDS: 3.12 f8fac708 2020-05-20 09:17:38 Details Diff |
0004401: Oracle ntype characters lost from conversion in capture |
Affected Issues 0004401 |
|
| mod - symmetric-client/src/main/java/org/jumpmind/symmetric/db/oracle/OracleTriggerTemplate.java | Diff File | ||
| mod - symmetric-core/src/main/java/org/jumpmind/symmetric/db/AbstractTriggerTemplate.java | Diff File | ||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2020-05-15 14:11 | elong | New Issue | |
| 2020-05-15 14:11 | elong | Status | new => assigned |
| 2020-05-15 14:11 | elong | Assigned To | => elong |
| 2020-05-15 14:11 | elong | Tag Attached: character encoding | |
| 2020-05-15 14:11 | elong | Tag Attached: dialect: oracle | |
| 2020-05-15 14:12 | elong | Relationship added | related to 0004374 |
| 2020-05-20 13:18 | elong | Status | assigned => resolved |
| 2020-05-20 13:18 | elong | Resolution | open => fixed |
| 2020-05-20 13:18 | elong | Fixed in Version | => 3.12.0 |
| 2020-05-26 18:48 | elong | Status | resolved => closed |
| 2020-06-04 17:55 | admin | Changeset attached | => SymmetricDS 3.12 f8fac708 |