Forum ‹ BigDB ‹ Bug: Indexing on String vs. Long for large numbers

[cjcenizal]

I recently tried to create an index on my PlayerObject table using a user's Facebook ID (which is stored as an object property). These IDs are completely numerical, and up to 15 digits in length. How many digits can be stored in a long? Building the index as a long on this 15-digit FB ID doesn't work (the index never seems to build). Building it as a string works fine, though. Is this expected behavior?

[Oliver]

That is because you've saved the value (from flash probably) as a string. It's a string with a numeric value, like this: "12345". We don't try to auto-cast values from one data type to another, so you have to be sure to store values in the right type.

- Oliver

[cjcenizal]

Ah, that makes sense. Thanks, Oliver.