Preceding Space of Attributes Trimmed Away After Import Into IDG

Products

• CA Identity Manager
• CA Identity Governance
• CA Identity Portal

Issue/Introduction

We noticed that when we import accounts from application with a preceding space, the preceding space is trimmed away. The space at the back is retained though.

personID,userName,orgName,orgType,shortName,LDAPName,Status,Last Login Date,Created Date
" K0182090 "," K0182090 ",,"KBANK",," K0182090 ","Enabled",,"2018-03-19 14:04:52.03"

Is it possible to retain the preceding space?

Environment

Release:
Component: SGRM

Resolution

Spaces - hexadecimal 20 are not allowed by the underlying DB  whether they are trailing or preceding.
If importing Hex 20 in the preceding string or trailing it, the SQL will be rejected. 
Meanwhile, hexadecimal A0 space (no break space) is allowed. These characters are respected in the DB but are not shown in the IG UI.