I'm guessing you have to have it in a form you can search it (so you can't just GZIP it or something like that)?
If you want a kludge for this, it's better to generate a longish random string (e.g., a UUID) to indicate an empty value.
One issue that might arise with altering historical data that I can imagine would be if it was ever necessary to restore from backup and your backup was made before you later added the zero width space, and then you forget to add the zero width space again when you restore from backup a few months down the road. But with proper documentation and procedures that shouldn't happen.
string_to_store = userstring + extra space
dynamo.store(key, string_to_store)
...
stored_string = dynamo.retrieve(key)
user_string = stored_string - extra space
That way the user puts a string in and gets the same string out. No problem.I did this to convert some String Sets (SS) in my database to String Lists (L). I almost did this same thing to fix the empty String issue but didn't have the time to implement it yet.
http://docs.aws.amazon.com/AWSJavaSDK/latest/javadoc/com/ama...