Values displays as ??? in Caspio Table

[ArthurLeywin]

Hello,

I am trying to make a school project, creating a simple enrollment app but while testing I encountered this

As you can see, some of the values in my table contains "??". I am not sure if that is because I am using chinese and korean characters for those values? I am using formula field for the Subjects and I want to use it for display in a Reports DataPage.

Anyone knows why this is happening and if there is something I can do about it?

Thanks!
AL

[Tubby]

Hi Arthur.

I found this in Caspio's HowTo Articles: https://howto.caspio.com/function-reference/

I thought it might help you. Check under "Text Functions".  Basically, you will just need "N" before the single quotes that wrap your values in the formula field.

For example:


This way, your values will be converted to NVARCHAR which allows Unicode characters which most other language characters are. This will not affect your normal English characters.

Here is a sample output on the table and on a report datapage:




It even works with emoticons/emojis. 

I hope this helps you. Good luck on your project.

~Tubbs

 

[GoodBoy]

Hello,

Just to add on this, the information about the N function is also included in this article at the bottom part.  

[ArthurLeywin]

@Tubby Thank you for giving a sample. This helped a lot.

Thanks for the help guys! Those articles are very helpful. 


-AL