What is the size of the string datatype? Is it 500 characters ?

Data Service
1

I tried adding TEXT as well as String as Data Type of the column of the Table. It seems that both have the length of 500 characters. Is this true?

If yes, how can I store more than 500 charecters?

2

Hi Charanjit,

Columns of type TEXT have a limit of 2000 characters. I am curious, what made you think the limit is 500 characters there?

Regards,
Mark

3

Hello,

using the iOS SDK, I’ve just tried to save an object containing a string property, with a length of 793. I got an error message saying that the size exceeds the limit of 500. I suppose Charanjit got into the same issue.

When I try to run again the app, and save the same data (in order to retrieve the exact error message I saw last time :), I have another error message :

error saving the flower : Server.Processing : java.lang.RuntimeException: java.lang.RuntimeException: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table ‘30D7FA5B-421F-CD39-FF1D-A77C9FDDEA00.Flower.93CE67BA-AE77-B19F-FF75-E48B50360E00’ doesn’t exist : java.lang.RuntimeException: java.lang.RuntimeException: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table ‘30D7FA5B-421F-CD39-FF1D-A77C9FDDEA00.Flower.93CE67BA-AE77-B19F-FF75-E48B50360E00’ doesn’t exist

I’m going to look into it…

4

ouch… When I go back to my app dashboard, I get an error message :

Internal server error with id 1507C62C-F403-BC6D-FF1E-E8C5FC624700

5

Does it still happen for you?

6

No, the issue has been solved in another topic. The point is to use “TEXT” in the database schema, instead of STRING, to avoid the error. Thanks.

7

image

Hi, as it clears in the attached screenshot, it seems “Text” column limit changed to 500 and I can not enter more than that. Why every day we have surprise in backendless?

8

Hello @sina

This is a known issue that will be fixed in the next release.
But you can use API and add text of required length. As soon as this bug is fixed, we will let you know about it.

Regards,
Inna

9

Hello @sina

We’ve just updated cloud servers with a fix for the issue you described above. Could you kindly let us know whether fix works for you well?

Regards,
Inna