# unaccent — Postgres extension

> Remove accents from text for search.

Source: https://scribase.com/extensions/unaccent

Category: Text search and indexing. Version: 1.1. Optional, enabled per project.

## About

unaccent is a text search dictionary and a function that strips diacritics, so a search for "creme brulee" finds "Crème brûlée". Use it in full-text search configurations or when normalizing names for matching.

## Enable it

```sql
create extension if not exists unaccent with schema extensions;
```

## Example

```sql
select unaccent('Crème brûlée');   -- Creme brulee

select name from dishes
where unaccent(lower(name)) like unaccent(lower('%creme%'));
```

## Notes

- unaccent() is not marked IMMUTABLE, so to index it wrap it in your own immutable function that names the dictionary explicitly.

Upstream: https://www.postgresql.org/docs/17/unaccent.html