- Thank you very much for your reply! - With such a change, I wonder if it is possible for me to continue to view the documentation for H2Database 1.x at a documentation address somewhere? I kind of want to compare the two different versions of the documentation, but I pay attention Go to https://github.com/h2database/h2database.github.io and there is no Git Tag for H2Database 1.x.
在2022年8月4日星期四 UTC+8 16:05:42<Evgenij Ryazanov> 写道： > You can read data type name and other parameters from the COLUMNS table: > https://h2database.com/html/systemtables.html#information_schema_columns > DATA_TYPE column now contains the name as required by the SQL Standard. > > For ARRAY data types there is an additional table with definitions of > elements: > > https://h2database.com/html/systemtables.html#information_schema_element_types > > For row value data types you need another additional table with > definitions of fields: > https://h2database.com/html/systemtables.html#information_schema_fields > > All these tables in H2 2.*.* are compliant with the SQL Standard. > > Non-standard ENUM data types have an own non-standard table with possible > values: > > https://h2database.com/html/systemtables.html#information_schema_enum_values > > In old versions of H2 INFORMATION_SCHEMA.COLUMNS.DATA_TYPE was incorrectly > used for JDBC type code. H2 2.*.* doesn't report JDBC-specific information > in the INFORMATION_SCHEMA, but you can read it from JDBC database metadata, > if you wish. > -- 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/24337687-f5a2-436e-abd8-9b0ad0e77255n%40googlegroups.com.
