What is the difference between varchar and text. H2 specifically rejects using unique or primarykey for text fields.

I am looking at the list of types supported by h2
http://www.h2database.com/html/datatypes.html
I don't see type text mentioned.
I remember that type from mysql though.

Anyway, if you don't know what type text is why do you want to use it?
Just use varchar.

> Also, this does not solve the problem of caching the preparedStatement in the function.

Consider using merge statement
http://www.h2database.com/html/grammar.html#merge

--
You received this message because you are subscribed to the Google Groups "H2 
Database" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to 
[email protected].
For more options, visit this group at 
http://groups.google.com/group/h2-database?hl=en.

Reply via email to