Special characters getting inserted into tables

Document ID : KB000016538
Last Modified Date : 14/02/2018
Show Technical Document Details
Question:

Why is Fast Data Masker (FDM) inserting special characters?

Environment:
CA Test Data Manager (TDM)- Fast Data Masker (FDM)
Answer:

The reason special characters are being seen in your data is due to a corruption in your database or seed list.

To find the special character, run the following query:

    select * from <database>.<table> where <column> = '<seed_list>';

    (For example:  select * from SCRAMBLE.GTSRC_REFERENCE_DATA where rd_ref_id = 'US Address1';)

This will present all the data where you can visually locate the "corrupt" data or see the additional characters.

 

Then you will need to look at the values to see if you can spot the special character. You can do this by running the following query:

    select * from <database>.<table> where <column> = '<seed_list>' and rd_ref_value like '%¿%';

    (For example:  select * from SCRAMBLE.GTSRC_REFERENCE_DATA where rd_ref_id = 'US Address1' and rd_ref_value like '%¿%';)

 

Once the special character is identified, you can edit it with the following query:

    update <database>.<table> set rd_ref_value = replace(rd_ref_value,'¿', ' ');

Additional Information:

If you experience any further issues, please open a support case by going to https://support.ca.com/us.html