Re: German "umlaut insensitive" query
"Jonathan S. Katz" <[email protected]> Fri, 20 Sep 2019 08:17:15 -0400
| Newsgroups | gmane.comp.db.postgresql.sql |
|---|---|
| Message-ID | <[email protected]> |
--Apple-Mail=_74C9D143-6709-4A83-A2FF-49D0DD6ACBE9 Content-Type: multipart/alternative; boundary="Apple-Mail=_367ECF11-7989-4905-AB22-C00B7921F89C" --Apple-Mail=_367ECF11-7989-4905-AB22-C00B7921F89C Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=utf-8 > On Sep 20, 2019, at 4:36 AM, <[email protected]> = <[email protected]> wrote: >=20 > Hi, >=20 > i found an entry from 2004, where it is about the German Umlaute and i = have the same problem. > https://www.postgresql.org/message-id/4135E7F5.4070002%40stroetgen.de = <https://www.postgresql.org/message-id/4135E7F5.4070002%40stroetgen.de> >=20 > I also found this article: > = https://dba.stackexchange.com/questions/195502/postgres-collate-example-in= -select = <https://dba.stackexchange.com/questions/195502/postgres-collate-example-i= n-select> >=20 > Are there other possibilities today (for example COLLATE) besides = replace() to process the German Umlaute? > In the long term, we also want to use it for other countries. There is a feature in the upcoming PostgreSQL 12 release that allows for accent insensitive queries: = https://www.postgresql.org/docs/12/collation.html#COLLATION-NONDETERMINIST= IC = <https://www.postgresql.org/docs/12/collation.html#COLLATION-NONDETERMINIS= TIC> This is part of PostgreSQL=E2=80=99s support for ICU collations. Thanks, Jonathan --Apple-Mail=_367ECF11-7989-4905-AB22-C00B7921F89C Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=utf-8 <html><head><meta http-equiv=3D"Content-Type" content=3D"text/html = charset=3Dutf-8"></head><body style=3D"word-wrap: break-word; = -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" = class=3D""><br class=3D""><div><blockquote type=3D"cite" class=3D""><div = class=3D"">On Sep 20, 2019, at 4:36 AM, <<a = href=3D"mailto:[email protected]" = class=3D"">[email protected]</a>> <<a = href=3D"mailto:[email protected]" = class=3D"">[email protected]</a>> wrote:</div><br = class=3D"Apple-interchange-newline"><div class=3D""><div = class=3D"WordSection1" style=3D"page: WordSection1; font-family: = Helvetica; font-size: 12px; font-style: normal; font-variant-caps: = normal; font-weight: normal; letter-spacing: normal; text-align: start; = text-indent: 0px; text-transform: none; white-space: normal; = word-spacing: 0px; -webkit-text-stroke-width: 0px;"><div style=3D"margin: = 0cm 0cm 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" = class=3D""><span lang=3D"EN-US" style=3D"" class=3D"">Hi,<o:p = class=3D""></o:p></span></div><div style=3D"margin: 0cm 0cm 0.0001pt; = font-size: 11pt; font-family: Calibri, sans-serif;" class=3D""><span = lang=3D"EN-US" style=3D"" class=3D""><o:p = class=3D""> </o:p></span></div><div style=3D"margin: 0cm 0cm = 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" = class=3D""><span lang=3D"EN-US" style=3D"" class=3D"">i found an entry = from 2004, where it is about the German Umlaute and i have the same = problem.<o:p class=3D""></o:p></span></div><div style=3D"margin: 0cm 0cm = 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" = class=3D""><span style=3D"" class=3D""><a = href=3D"https://www.postgresql.org/message-id/4135E7F5.4070002%40stroetgen= .de" id=3D"LPlnk721696" style=3D"color: purple; text-decoration: = underline;" class=3D""><span lang=3D"EN-US" = class=3D"">https://www.postgresql.org/message-id/4135E7F5.4070002%40stroet= gen.de</span></a></span><span lang=3D"EN-US" style=3D"" class=3D""><o:p = class=3D""></o:p></span></div><div style=3D"margin: 0cm 0cm 0.0001pt; = font-size: 11pt; font-family: Calibri, sans-serif;" class=3D""><span = lang=3D"EN-US" style=3D"" class=3D""><o:p = class=3D""> </o:p></span></div><div style=3D"margin: 0cm 0cm = 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" = class=3D""><span lang=3D"EN-US" style=3D"" class=3D"">I also found this = article:<o:p class=3D""></o:p></span></div><div style=3D"margin: 0cm 0cm = 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" = class=3D""><span style=3D"" class=3D""><a = href=3D"https://dba.stackexchange.com/questions/195502/postgres-collate-ex= ample-in-select" id=3D"LPNoLP171326" style=3D"color: purple; = text-decoration: underline;" class=3D""><span lang=3D"EN-US" = class=3D"">https://dba.stackexchange.com/questions/195502/postgres-collate= -example-in-select</span></a></span><span lang=3D"EN-US" style=3D"" = class=3D""><o:p class=3D""></o:p></span></div><div style=3D"margin: 0cm = 0cm 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" = class=3D""><span lang=3D"EN-US" style=3D"" class=3D""><o:p = class=3D""> </o:p></span></div><div style=3D"margin: 0cm 0cm = 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" = class=3D""><span lang=3D"EN-US" style=3D"" class=3D"">Are there other = possibilities today (for example COLLATE) besides replace() to process = the German Umlaute?<o:p class=3D""></o:p></span></div><div = style=3D"margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: = Calibri, sans-serif;" class=3D""><span lang=3D"EN-US" style=3D"" = class=3D"">In the long term, we also want to use it for other = countries.</span></div></div></div></blockquote><br = class=3D""></div><div>There is a feature in the upcoming PostgreSQL 12 = release that</div><div>allows for accent insensitive = queries:</div><div><br class=3D""></div><div><a = href=3D"https://www.postgresql.org/docs/12/collation.html#COLLATION-NONDET= ERMINISTIC" = class=3D"">https://www.postgresql.org/docs/12/collation.html#COLLATION-NON= DETERMINISTIC</a></div><br class=3D""><div class=3D"">This is part of = PostgreSQL=E2=80=99s support for ICU collations.</div><div class=3D""><br = class=3D""></div><div class=3D"">Thanks,</div><div class=3D""><br = class=3D""></div><div class=3D"">Jonathan</div></body></html>= --Apple-Mail=_367ECF11-7989-4905-AB22-C00B7921F89C-- --Apple-Mail=_74C9D143-6709-4A83-A2FF-49D0DD6ACBE9 Content-Transfer-Encoding: 7bit Content-Disposition: attachment; filename=signature.asc Content-Type: application/pgp-signature; name=signature.asc Content-Description: Message signed with OpenPGP -----BEGIN PGP SIGNATURE----- iQIzBAEBCAAdFiEE+oS2la8r95ogZD/x8QSccp8cZScFAl2Ew0sACgkQ8QSccp8c ZSc9GQ/+N7ZsJMz4QQft/UmSsC5vjnruva5MpMVfLX3sYWmZxV2OX2Jb+r3mmpyb 0nJN6bs+vhHEtabUz6p+1+Lc0FPRbbpEcG9qKEDF38ne9LnzIW58UUr11ktQZQnc 2l28kyv+n14uQ53YTCFRjxysRYX1f/gt37909pAlCL7bnX7rNQS0WUZ2f3wAh8jg QRlrnftK0A5snd7PposaV0vpksA8ov7Iza6REXZkGAXoDcdoM66t5w+Xw/oQ+vXC AZiE1JxY8zZF+R6z6J8ZXhWIDfuxk5Wzoqlb3kpniFtCDYJPsda0uW1r3T2+CaLF 2HknSt6D9TA+qHVKhtzDigDO68hnjvYeMaAzg+/5R3iRsEM4FFPMsf6jYZejfBcz VgEJo/CHYzAOfBZOTXAomAaPzIum5cGbw3Fr17rxW+jR9z3cAj0wNWScdiAtd2f2 Bo51lRKu9JZCo/fCCurEkCnD0nJH/CoVcAvSJ9ow4FLEOV2+hX2xpd8YcLswJkvH ggwHBT6he+GyPkyP8gXmtRlng72BlQH4JBzDS64ZJ5rj+7hJ1oKvm2qtPruUeSSS 5eoF8ElGShNA/q2G5+UtFHHXapNUcnehjNsyMo6/IqgzRtb+F3DhS5SyTCpg3NjM bqurTMWJK4zhZFbheg/nN7z/iP7cANRb+fI7oAnJawaWDTe++pk= =0BfC -----END PGP SIGNATURE----- --Apple-Mail=_74C9D143-6709-4A83-A2FF-49D0DD6ACBE9--