Database Table Checkpoint - LongText Field type seen as type BLOB

I am trying to do database table comparisons in my keyword tests and if a table has a field type in Access as LongText then TestComplete sees it as BLOB. This does not allow me to accurately compare the results. Has anyone else ran into this issue, and how did you navigate it?

I've tried to submit a help ticket but got no where the support, they wanted me to change the field type to something else, however I am not able to do that as it is customer driver. Hoping maybe there is a solution w/in the community.