Special characters getting inserted into tables

book

Article ID: 16538

calendar_today

Updated On:

Products

CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction



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

Environment

CA Test Data Manager (TDM)- Fast Data Masker (FDM)

Resolution

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