I am trying to update a Clob with the following JSON string. I get untranslatable character error in java. If you see the number is converted into european format (4 052,00) but they are strings. Not sure whether this is causing the problem.
I tried changing the column character set to UNICODE but no help. Any help would be appreciated.
If you can insert the string into a varchar latin or unicode column, then it is not a repertoire issue.
The JSON standard falls short when it comes to I18N. There is no support for localized formating (e.g., ',' as radix) and parsing of numeric, monetary, date, and time(stamps), etc. You'll need to format each individual substring value using the en-US locale (default SDF values to tdlocaledef), and concat them together before the update.