(CFA TEST) UOM Import Converts Special Characters to Question Marks in Database

Testing Environment Details

Testing Environment Details
Effected Server: Testing (R3)
Store(s): N/A
Logged in User: N/A (Server Manager)

Feature: All - INTL - Support special characters in Imports/Exports
Related Tickets (Stories or Features): CFAMX-13217 - Localization: Update UOM Import to Support Special Characters
Other Related Links (Confluence, BRDs, Etc...): N/A
Feature Configurations: N/A

Steps:

1. Login to Server Manager
2. Update the UOM CSV File with Special Characters (Ex. LáÁéÉíÍóÓ|LáÁéÉíÍóÓ|12)
3. Drop the file on the server manager W:\Macromatix\SiteData\CFATesting\DataImports\Items
4. Run the UOM Import under Data Imports for Server Manager - CFATesting
5. Run the below in Database and check the last line

Expected Result:

Database should contain special characters

Actual Result:

Database contains converted special characters which are now question marks

Notes:

• Import File:
  • UOM_20200221_0245_A_20210426.csv
• Log:
  • UOM-Trace.Log
• SQL:
  •