Hi,
<< CSVREAD apparently don't support datatypes other than VARCHAR in the
DB >>
when reading data with CSVREAD, you are free to convert or CAST the
strings to NUMERIC or DATE columns.
_
Example:_
select
CAST(COL1 as DOUBLE) as COL1,
...
from CSVREAD()
Regards
Le 23/07/2020 à 12:42, George Ivanov a écrit :
Hi Matt, Evgenij,
there is still a question about converting JSON to CSV and then using
CSVREAD.
When the conversion is performed and CSV is read to the DB, the data
looses its datatype (since CSV and CSVREAD apparently don't support
datatypes other than VARCHAR in the DB).
So, I guess, JSONREAD (as least for a flat JSON arrays) would be
useful, since it could be implemented in a way that would preserve the
datatypes from original JSON.
What do you think?
--
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]
<mailto:[email protected]>.
To view this discussion on the web visit
https://groups.google.com/d/msgid/h2-database/bf0f5e06-ba4c-4bbc-956c-be69aa722735o%40googlegroups.com
<https://groups.google.com/d/msgid/h2-database/bf0f5e06-ba4c-4bbc-956c-be69aa722735o%40googlegroups.com?utm_medium=email&utm_source=footer>.
--
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/9f5fc18f-0612-8d5c-b7d7-723d7a737290%40gmail.com.
