double byte vs single byte characters

[NCD]

I found out that while "ＴＨＩＳ" and "THIS" are considered to be identical,

"コレ" and  "ｺﾚ" are considered as different.

It seems like I have to go back to my database and edit all (thousands) of the rows,

and make it either a single byte or a double byte.

which is a pain in my butt...

Any good ways to approach this or is this something I'd just have to do?

[NCD · Accepted solution]

Figured this out by just doing ASC on the Spreadsheet side, and just remember to use ONLY single bytes from now on...

But would love for Japanese letters to be considered as identical as well...