Wappler Version : 4.4.5
Operating System : W10
Server Model: Node
Database Type: Mysql 8
Hosting Type: Docker
Expected behavior
When querying for a json object in both my local dev environment and live database (managed database from DigitalOcean) I expect to get the data in the same format.
Actual behavior
What actually happens?
The format is different:
-
This is the query in my local database
-
This is the data from the remote database on live:
- This is the data compared (using DBeaver to view the data):
The data is identical
- These are the settings in wappler, and the db.json:
Local:
Live:
I need the data in the exact same way. Right now I assumed it would available to me in the local way, so I use a parseJSON() function to process it. However it’s already parsed for the live database. So there I’m not able to display this data properly.
My best guess is that this is hidden somwhere in a wappler file? https://dev.mysql.com/doc/refman/8.0/en/json-attribute-functions.html#function_json-type
Last updated: