Hello. It sounds like your database is not normalized properly. I suggest you to read a some book about database design or at least some articles about database normalization.
For your specific use case you need to extract all possible values for each such column into own table that has a column with integer primary key and a column with a string value. In the main table these string columns should be replaced with integer columns with foreign key references to the new tables. This area is under responsibility of database engineers. -- 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/368d26d8-8546-4b66-b5be-25c038de2fa6%40googlegroups.com.
