"auto" is going to be subjective because JSON types aren't 1:1 to SQL types for number precision. To retain precision in JSON, one is forced to store those values as strings instead of numbers.
ref: https://www.w3schools.com/js/js_numbers.asp On Thursday, July 23, 2020 at 9:27:20 AM UTC-5, George Ivanov wrote: > > yes, however, I'd like the types to be automatically preserved from the > original JSON types. > I don't want to manually populate the types. Instead I'd like, for > example, to analyze the datatypes from JSON but in the H2 DB using SQL > -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/h2-database/3fe3c9e0-3f4f-4ecd-a465-66b2c6c58595o%40googlegroups.com.
