July 31, 2019 at 4:22 pm #26148sahoobParticipant
We have few json data are stored on string data type (SYNTAX 18.104.22.168.4.1.1422.214.171.124.15) field on DJ 3.5. Could it possible to change the data type of those fields to json datatype (SYNTAX 126.96.36.199.4.1.14188.8.131.52.5)?
BiswajitJuly 31, 2019 at 4:50 pm #26149JnRouvignacParticipant
184.108.40.206.4.1.14220.127.116.11.5is binary syntax, i.e. not what you want.
Json syntax is only implemented since 4.0 if I remember correctly. The OID is
Are the current data using a valid JSON format?
In that case it is possible to change the schema without problem. Note that you may also have to change the equality matching rule: to
Jean-NoelJuly 31, 2019 at 4:50 pm #26150LudoModerator
The syntax 18.104.22.168.4.1.1422.214.171.124.5 is Binary, and not related to JSON datatypes.
Changing the syntax for an existing attribute is possible but not recommended.
There could be side effects such as requiring to rebuild indexes if there are any index, but also possibly the inability to delete specific values (if they are not fully compliant with the JSON syntax).July 31, 2019 at 4:57 pm #26151sahoobParticipant
Thanks Jean-Noel and Ludo,
Sorry wrongly copy/paste the OID for json. yes the correct one is 126.96.36.199.4.1.367188.8.131.52.1
Yes our data is valid json format and currently no index is defined for those data.
So if we change the datatype on this data set. does you see any impact? or its recommend to continue using on the string datatype?
You must be logged in to reply to this topic.