Stack Overflow
Stack Overflow

Questions tagged [unaccent]

32 questions
1
vote
1 answer

Grails / Gorm and Postgresql Unaccent

I have a question about how to use unaccent extension of PostgreSQL with Grails. I have a lot of descriptions in french and PostgreSQL is not accent insensitive. I installed the unaccent extension and it works very well on PgAdmin III. How can I…
Abincepto
  • 1,016
  • 8
  • 13
1
vote
2 answers

Unaccent extension of Postgresql 9.1 returning empty row

I created the extension "unaccent" on the postgresql database but when I run a select using the "unaccent" it always return 1 row but with a blank line. select ts_lexize('unaccent', 'Hôtel'); ts_lexize ----------- (1 row) Expected according to the…
Tarantula
  • 19,031
  • 12
  • 54
  • 71
0
votes
0 answers

Encoded values to plain text in Redshift

I have encoded values in the table, and wanted to select them as a plain text without altering the database property, I have tried many ways, but not getting exact result. Value - Er tręäńgt keinen Manteł Expected - Er treangt keinen Mantel SELECT…
Jim Macaulay
  • 4,709
  • 4
  • 28
  • 53
0
votes
1 answer

How to unaccent special characters in PySpark?

I have a spark df with a string column with special characters such as áãâàéêèíîìóõôòúûùç and I want to replace them with respectively aaaaeeeiiioooouuuc As an example of what I want: name | unaccent Vitória | Vitoria João …
Tiago Shimizu
  • 265
  • 1
  • 2
  • 7
0
votes
0 answers

How to make diacritics insensitive queries in PostgreSQL, without unaccent extension?

I need to do queries ignoring diacritics (and case) in PostgreSQL 9.3. Everything I've found about it (e.g. here, here and here) requires the installation of the unaccent extension. However, I cannot have it installed on my server. Is there another…
Rodrigo
  • 4,706
  • 6
  • 51
  • 94
0
votes
1 answer

Use unaccent postgres extension in Knex.js Querys

I need make a query for a postgresdb without identify accents (á, í,ö, etc). I'm already use Knex.js as query builder, and postgresql have a unaccent extension that works fine in sql querys directly to db, but in my code i use knex and unaccent…
Chayder
  • 1
0
votes
2 answers

UNACCENT when checking for UNIQUE contraint violations in PostgreSQL

We have a UNIQUE constraint on a table to prevent our city_name and state_id combinations from being duplicated. The problem we have found is that accents circumvent this. Example: "Montréal" "Quebec" and "Montreal" "Quebec" We need a way to have…
Matt Weber
  • 2,808
  • 2
  • 14
  • 30
0
votes
1 answer

Store custom files on heroku postgres database

I am trying to create custom rules for the builtin function unaccent on postgres. Postgres' documentation states This file must be stored in $SHAREDIR/tsearch_data/ (where $SHAREDIR means the PostgreSQL installation's shared-data directory). Its…
Naufal Khalid
  • 409
  • 2
  • 6
  • 11
0
votes
0 answers

django.contrib.postgres missing/not installing on Heroku Django

I'm using the unaccent extension for Postgres and followed all the docs to get it to work (installed the extension directly via CREATE EXTENSION and put django.contrib.postgres in INSTALLED_APPS in django settings). In local environment it's working…
RK Dev
  • 1
  • 3
0
votes
1 answer

Amazon RDS + PostgreSQL + accent + like

I'm having a lot of troubles using the configuration described in the title. My problem : I have a PostgreSQL DB 10.0 in AWS RDS The DB is configured with UTF-8 I have a table with descriptions of diseases in french (so, with accents) I want to…
Juanse
  • 95
  • 8
0
votes
0 answers

Wildcard characters and unaccent in pg-promise query

I use pg-promise@8.4.4 and I would like to have wildcard characters and the unaccent function of the PostgreSQL. My pl/pgsql query has something like WHERE unaccent(p.name) ILIKE (''%'' || unaccent($1) || ''%'')' I want to make it into a…
slevin
  • 4,166
  • 20
  • 69
  • 129
0
votes
1 answer

Multi-column index with unaccent and pg_trgm (matching dirty data)

I have a table with customer data, it has 12M+ records. I want to query it based on few fields, for example: first_name, last_name, birth_place. But data are really dirty, so as a result I want even records that aren't completely matching. I'm using…
Wlad
  • 410
  • 1
  • 9
  • 27
0
votes
1 answer

Java text normalization behaving differently after deploying the war in tomcat

I'm trying to normalize a string that has accent characters. It runs fine on my intellij IDE, but when i build it using maven and deploy the war in tomcat, I get unexpected results like this. Can you please help? Java code to normalize String…
user52715
  • 1
  • 1
0
votes
1 answer

Postgres unaccent function for character

I'm using unaccent in Postgres but it cannot convert special character like: ù : ù but it's okay for ù: ù 2 characters same meaning but different code, the first one is character u + ̀ How I can solve this problem ? Thank you so…
lufutu
  • 33
  • 4
0
votes
1 answer

Postgres and unaccent extension default directory

I need to add an extension called unaccent to my postgres database. Postgres version PostgreSQL version: 9.3rc1 I have a problem to install the extension. What i did: sudo apt-get install postgresql-contrib-9.1 I know it's with 9.1 version, but…
mArtinko5MB
  • 756
  • 8
  • 18
1
2
3