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

Le jeudi 10 octobre 2013 10:43:06 UTC+2, Noel Grandin a écrit :

    http://h2database.com/html/grammar.html#create_alias
    <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 stop receiving emails from it, send an email 
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/groups/opt_out.

Reply via email to