Is it possible to store Chinese characters in google sheet?

[lanbolee]

Hey guys !
I want to create a storage system, and I want to store my data in my google drive.

However, I try so much time to store Chinese characters to my google sheet which is in my google drive, but app inventer2 always ignore the characters . Through testing, It is successful to store English characters and numbers(stored in text block, not stored in integer blocks) .For example : If I input "測試123中文test",and the output would be "123test"(ignore 4 characters "測" 、"試"、 "中"、 "文").

Sorry for that I have already searched on google many times about this question on Taiwan or other Countries' website, but nothing information could help me solve .
Here is what I followed steps from the video:https://www.youtube.com/watch?v=WuH-GBynC8U&t=380s&ab_channel=CrazyCodersClub thanks for helping!

[SteveJG]

Are you attempting to use App Inventor to control a googlesheet that is in Chinese?

Perhaps https://support.google.com/docs/answer/187189?co=GENIE.Platform%3DDesktop&hl=en

or use pinyin instead of glyphs?

or https://www.google.com/search?q=Chinese+googlesheet+example&rlz=1C1CHBF_enUS887US887&oq=Chinese+googlesheet+example&aqs=chrome..69i57.8632j0j7&sourceid=chrome&ie=UTF-8

[TIMAI2]

Try this method, is working for me...

• Google Sheets - Simple POST and GET Data

[lanbolee]

Thanks for your response! It doesn't like a language problem cause I try POST my data directly through url POST(e.g. http://myapiurl?data="測試123test") and it works and data is completely stored in google sheet

[lanbolee]

Thanks for your response! I will try it and figure out the problems.

[lanbolee]

It works!!
I guess there was something wrong on my codes

I used string to post , but I don't why string can't post completely .

I followed your advice and change String into list, and then address them from app script.

Finally, it is successful! thanks a lot for your helping! Have a good day!