This site uses cookies. By continuing to browse the site, you agree to our use of cookies. Find out more about cookies.
Skip to main content
Consultation Québec's official logo
  • English Choose language Choisir la langue
    • Français
Sign Up Sign In
  • Home
  • Consultations
  • Help

Données Québec : participez à son amélioration!

Consultation publique sur l’utilisation des données ouvertes et les améliorations possibles pour Données Québec

  • The consultation
  • Propositions
  • Sondage
chevron-left Back to list

Permettre la recherche insensible aux accents et aux ligatures

Avatar: Rémi Rémi
20/10/2021 17:53  
Accepted

1 - Description de la proposition :


Lorsqu'on utilise l'api sql pour faire une recherche, on peut passer à côté de résultats pour une différence d'accents ou de ligature.

L'utilisation du module unaccent, si c'est techniquement possible, pourrait résoudre ce problème.

https://www.postgresql.org/docs/current/unaccent.html


2 - La proposition vise à résoudre/améliorer quoi?  

https://www.donneesquebec.ca/recherche/api/3/action/datastore_search_sql?sql=SELECT * from "xxxxxxx-xxxxxxxxxx-xxxxxxxx" WHERE "TITRE" LIKE 'Œuvre'

aucun résultat


3 - En quoi la proposition résoudrait/améliorerait ce problème? 

avec unaccent, Œuvre et Oeuvre deviennent équivalents tout comme québec et quebec.

This proposal has been accepted because:

Merci pour votre proposition.

Effectivement, le module d’extension unaccent pourrait améliorer la recherche. Sa mise en place a été inscrite à la feuille de route de Données Québec.

9 Supports
Permettre la recherche insensible aux accents et aux ligatures Comments 9

Reference: participation_quebec-PROP-2021-10-149
Version number 4 (of 4) see other versions
Check fingerprint

Fingerprint

The piece of text below is a shortened, hashed representation of this content. It's useful to ensure the content hasn't been tampered with, as a single modification would result in a totally different value.

Value: ac247073b458dfded56bd43d75b11c6a6f2984c92b2ee4adcc357348aecefb63

Source: {"body":{"fr":"<p><strong>1 - Description de la proposition&nbsp;:</strong></p><p><strong><br></strong>Lorsqu'on utilise l'api sql pour faire une recherche, on peut passer à côté de résultats pour une différence d'accents ou de ligature.</p><p>L'utilisation du module unaccent, si c'est techniquement possible, pourrait résoudre ce problème.</p><p>https://www.postgresql.org/docs/current/unaccent.html</p><p><br></p><p><strong>2 - La proposition vise à résoudre/améliorer quoi?&nbsp;&nbsp;</strong></p><p>https://www.donneesquebec.ca/recherche/api/3/action/datastore_search_sql?sql=SELECT * from \"xxxxxxx-xxxxxxxxxx-xxxxxxxx\" WHERE \"TITRE\" LIKE '<strong>Œuvre</strong>'</p><p>aucun résultat</p><p><strong><br></strong></p><p><strong>3 - En quoi la proposition résoudrait/améliorerait ce problème?&nbsp;</strong></p><p>avec unaccent, Œuvre et Oeuvre deviennent équivalents tout comme québec et quebec.</p>"},"title":{"fr":"Permettre la recherche insensible aux accents et aux ligatures"}}

This fingerprint is calculated using a SHA256 hashing algorithm. In order to replicate it yourself, you can use an MD5 calculator online and copy-paste the source data.

Share:

link-intact Share link

Share link:

Please paste this code in your page:

<script src="https://consultation.quebec.ca/processes/donneesquebec/f/58/proposals/149/embed.js?locale=en"></script>
<noscript><iframe src="https://consultation.quebec.ca/processes/donneesquebec/f/58/proposals/149/embed.html?locale=en" frameborder="0" scrolling="vertical"></iframe></noscript>

Report inappropriate content

Is this content inappropriate?

Reason

9 comments

Order by:
  • Older
    • Best rated
    • Recent
    • Older
    • Most discussed
Comment moderated on 07/07/2022 12:31
Comment moderated on 26/07/2022 15:14
Comment moderated on 01/08/2022 09:14
Comment moderated on 08/08/2022 10:21
Comment moderated on 26/09/2022 12:48
Conversation with Ellen Smith
Comment moderated on 29/09/2022 11:36
Avatar: Ellen Smith Ellen Smith
21/09/2022 10:14
  • Get link Get link

But any news about this ?!

Conversation with markola
Avatar: markola markola
09/03/2023 23:52
Edited
  • Get link Get link

This is wonderful, and I think we can all agree that having this information is pretty vital; many thanks for providing it. https://spanishdictionary.cc/

Avatar: avajames8805 avajames8805
13/03/2023 10:07
  • Get link Get link

Nice post thanks for sharing check this https://www.savewithblogs.com/store-profile/lightinthebox-discount-code

Avatar: Vishal Singh Vishal Singh
14/03/2023 12:06
  • Get link Get link

hii

Conversation with Eric St-Cyr ProStar SEO Montréal
Avatar: Eric St-Cyr ProStar SEO Montréal Eric St-Cyr ProStar SEO Montréal
16/03/2023 12:43
  • Get link Get link

Bien d'accords.

https://www.prostarseo.com/en/best-seo-toronto
ProStar SEO Toronto Simply the Best SEO Agency in GTA #1 ......................Toronto SEO, SEO Toronto, best SEO, SEO companies, search engine optimization, SEO service, local SEO, SEO expert, and marketing agency. Best SEO company, companies in Toronto, best SEO company in Toronto, top SEO, SEO companies in Toronto, Toronto SEO companies, and top SEO companies. Toronto SEO services, top SEO companies in Toronto, search engine marketing, top Toronto SEO, SEO company Toronto, SEO in Toronto. Local SEO company. Toronto SEO, SEO service, SEO expert, search engine optimization, technical SEO, top x SEO, SEO Toronto, digital marketing, best SEO, ranking, SEO companies, local SEO, best SEO company, and companies in Toronto. Best SEO company in Toronto, top SEO, SEO companies in Toronto, SEO agencie

Avatar: gfnyt2 gfnyt2
17/03/2023 06:45
  • Get link Get link

https://india.escortgps.xxx/escort/gfnyt2/
https://www.colourinyourlife.com.au/members/gfnyt2/profile/
https://allmy.bio/gfnyt2
https://www.as7abe.com/wall/user/gfnyt2
https://www.geocities.ws/gfnyt2/index.html
https://3dprintboard.com/member.php?106601-gfnyt2
https://consultation.quebec.ca/profiles/gfnyt2/timeline?locale=en

Avatar: Lewis Wood Lewis Wood
20/03/2023 04:13
  • Get link Get link

Finally, something intriguing and new to read. If you want to achieve the same level of success for yourself, contact the assignment help service.
https://www.assignmenthelpservice.com/service/psychology-homework-help

Avatar: gfnyt2 gfnyt2
17/03/2023 06:46
  • Get link Get link

https://armorama.com/profile/gfnyt2
https://www.tfod.in/Profile-TrishaGupta
https://boersen.oeh-salzburg.at/author/gfnyt2/
https://demo.socialengine.com/profile/2704
https://www.anime-sharing.com/forum/members/gfnyt2-326740/
https://www.engineering.com/profile/gfnyt2
https://www.teachertube.com/user/channel/gfnyt2
https://www.propelio.com/academy/community/profile/gfnyt2/
https://www.openhumans.net/member/gfnyt2/

Avatar: gfnyt2 gfnyt2
17/03/2023 06:46
  • Get link Get link

https://www.mepits.com/tutorial/180/biomedical/wearable-biosensors
http://divisionmidway.org/jobs/author/gfnyt2/
http://giderosmobile.com/apps/gfnyt2
https://shapshare.com/gfnyt2
https://community.teltonika-networks.com/user/gfnyt2
http://teamworkmatters.ocbmedia.com/members/gfnyt2/profile/
https://www.ratethatrescue.org/wp/community/members/gfnyt2/profile/
http://heroescommunity.com/member.php3?action=viewprofile&UserName=gfnyt2

Add your comment

Sign in with your account or sign up to add your comment.

Loading comments ...

Consultation Québec
  • Frequently Asked Questions
  • Terms of Use
  • Privacy Policy
  • Netiquette
  • Accessibility
  • Contact Us
  • Consultation Québec at Twitter Twitter
  • Consultation Québec at Facebook Facebook

Confirm

OK Cancel

Please sign in

Sign up

Forgot your password?