View Issue Details

IDProjectCategoryView StatusLast Update
0006711SymmetricDS ProBugpublic2025-01-29 23:00
Reporterpmarzullo Assigned Topmarzullo  
Prioritynormal 
Status resolvedResolutionfixed 
Product Version3.15.0 
Target Version3.15.13Fixed in Version3.15.13 
Summary0006711: MSSql bulk loader using bcp fails to load some special characters when bcp is running on Windows
DescriptionWhen bcp runs on windows, there are certain characters that are not successfully loaded because of the code page definition that bcp uses by default.

An example character that fails to load when using bcp:
รป

An additional command line for the bcp can be added to make the load work:
-C 65001

This defines the code page of UTF-8.

A parameter will be added to allow the user to define a different code page and the parameters will be added to the command line when running bcp:
mssql.bulk.load.bcp.code.page
Steps To Reproduce1. Bulk load a table in SQL Server with the bcp running on Windows.
2. Make sure to have data that has the special character specified above.
3. The target table will not have that special character in the table.
Tagsbulk, dialect: sql-server

Activities

There are no notes attached to this issue.

Related Changesets

SymmetricDS: 3.15 775f5010

2025-01-29 22:19:29

pmarzullo

Details Diff
0006711: MSSql bulk loader using bcp fails to load some special
characters when bcp is running on Windows
Affected Issues
0006711
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/common/ParameterConstants.java Diff File
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/load/AbstractDataLoaderFactory.java Diff File
mod - symmetric-io/src/main/java/org/jumpmind/symmetric/io/data/writer/DatabaseWriterSettings.java Diff File

Issue History

Date Modified Username Field Change
2025-01-29 22:18 pmarzullo New Issue
2025-01-29 22:18 pmarzullo Status new => assigned
2025-01-29 22:18 pmarzullo Assigned To => pmarzullo
2025-01-29 22:18 pmarzullo Tag Attached: bulk
2025-01-29 22:18 pmarzullo Tag Attached: dialect: sql-server
2025-01-29 22:20 pmarzullo Status assigned => resolved
2025-01-29 22:20 pmarzullo Resolution open => fixed
2025-01-29 22:20 pmarzullo Fixed in Version => 3.15.13
2025-01-29 23:00 pmarzullo Changeset attached => SymmetricDS 3.15 775f5010