Solved: double byte vs single byte characters - Page 2

NCD · 03-13-2022 07:07 PM

Do double byte, single byte characters matter when using Google Sheets as your source?

I'm creating an app for a Japanese company and got me thinking, do double byte characters take up more storage than single byte characters?

And if I create a enum and column and prohibit people from creating existing values with an expression, would it considerＴＨＩＳ and THIS as the same value?

Kirk_Masden

I agree that it's an interesting question. I found that when using the AppSheet search function, the two are considered to be identical:

But, as @takuya_miyai pointed out, if you make an expression like "ＴＨＩＳ"="THIS" it will be false.

It would be nice if we had the capability of converting such codes within AppSheet. A text funtion like SINGLEBYTE() would be nice. Then, SINGLEBYTE("ＴＨＩＳ")=SINGLEBYTE("THIS") would be true.

I think there's a strong possibility that users in Japan will type in both double and single bytes so some way to work around such user behavior would be nice.

View solution in original post