I've confirmed that case-sensitivity was not the root cause of the mapping issue -- it was carriage returns at the end of the string. When I tested by changing the gridsquare to upper-case in my database, the carriage return got removed. This gave us a false positive that it was a case issue. I have tested withwith XX11xx grid squares and have confirmed that case makes no difference.