Hi, > I would like to know if the precision specified for a table column's > type (as in e.g. "FOO VARCHAR(42)") has an impact on the size of the > database. Is the database file larger if I leave out any such > constraints (provided that the data is the same as in a database with > constraints)?
See http://h2database.com/html/datatypes.html#varchar_type "The precision is a size constraint; only the actual data is persisted." > Also is there a notable impact on performance when these > constraints are specified? No. Regards, Thomas -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to h2-database@googlegroups.com. To unsubscribe from this group, send email to h2-database+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
