I have a table which stores 7 chars string key which will be read by application for validation. The problem I am facing is, I am not able to validate key if it contains alphanumeric and special characters (example: oFemT7M). If I change key to all numeric say 1111111 then validation works fine.
Is this related to character encoding or something else ? I checked my prod database with dev and only difference I can see in time zone. Prod database has timezone as America and Dev database is having Asia.
We have 7 single char text boxes on the UI, when user enters value in those and clicks on submit, we are concatinating 7 chars from text boxes and sending those to service. Service will validate this 7 chars string with string from database, if it matches then validation is successful and user is allowed to proceed further.