View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0002783 | SymmetricDS | Bug | public | 2016-09-09 18:59 | 2023-09-13 17:49 |
| Reporter | gatokino | Assigned To | |||
| Priority | normal | ||||
| Status | closed | Resolution | won't fix | ||
| Product Version | 3.8.3 | ||||
| Summary | 0002783: PostgresqBulk is failling with org.postgresql.util.PSQLException invalid UTF-8 sequence | ||||
| Description | initial load with postgres_bulk is failling agains a postgres database that is in UNICODE character set using a symmetricds in a virtual java machine with another character encoding | ||||
| Additional Information | the fault is comming because bytes are sent in the java String default encoding instead of database encoding byte[] dataToLoad = formattedData.getBytes(); copyIn.writeToCopy(dataToLoad, 0, dataToLoad.length); A solution is to use unicode encoding in COPY FROM command and sending the data in UTF-8 format changes are: line 105: byte[] dataToLoad = formattedData.getBytes("UTF-8"); line 231: sql.append("FROM STDIN with delimiter ',' csv quote '''' ENCODING 'UNICODE'"); | ||||
| Tags | bulk, dialect: postgresql | ||||
| related to | 0002257 | closed | Loading TEXT field with postgres_bulk loader: invalid byte sequence for encoding "UTF8": 0x00 |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2016-09-09 18:59 | gatokino | New Issue | |
| 2016-09-09 18:59 | gatokino | File Added: PostgresBulkDatabaseWriter.java | |
| 2016-09-30 01:01 | admin | Status | new => closed |
| 2016-09-30 14:28 | admin | Status | closed => new |
| 2016-09-30 14:28 | admin | Note Added: 0000875 | |
| 2019-04-24 13:10 | elong | Tag Attached: bulk | |
| 2019-04-24 13:10 | elong | Tag Attached: dialect: postgresql | |
| 2022-09-09 21:29 | elong | Relationship added | related to 0002257 |
| 2023-09-13 17:49 | emiller | Status | new => closed |
| 2023-09-13 17:49 | emiller | Resolution | open => won't fix |