Using unaccent on H2 database

[BeginnerH2]

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 you.

[Noel Grandin]

http://h2database.com/html/grammar.html#create_alias

[Noel Grandin]

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 looking how to install the extension unaccent on the database H2, it is possible?

In fact, My SQL query is run on two databases : PostgreSQL and H2, if I use CREATE ALIAS it will work on H2 database but it will not work on PostgreSQL.

I inform you that I have installed on unaccent postgrSQL and it works.

thanks.