[h2] Using unaccent on H2 database

Hello, When I use unaccent on H2 database I have a kind exception: Caused by: java.sql.SQLException: Unexpected token: UNACCENT in statement I think that Unaccent function is not supportable on the database H2 Database. there is a hard way to create or add this function on H2 database? Thank

Re: [h2] Using unaccent on H2 database

http://h2database.com/html/grammar.html#create_alias On 2013-10-10 10:13, BeginnerH2 wrote: there is a hard way to create or add this function on H2 database? -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and

Re: [h2] Using unaccent on H2 database

UNACCENT appears to be a PostgreSQL specific function, which we do not support. However, if you are trying to do some kind of full-text search, we support Lucene: http://h2database.com/html/tutorial.html#fulltext On 2013-10-10 12:07, BeginnerH2 wrote: thank you for your answer but I'm lo