From jkarlen@karlen.com Sun Dec 5 15:39:48 1999 Received: from onyx.he.net (onyx.he.net [216.218.161.2]) by hub.org (8.9.3/8.9.3) with ESMTP id KAA24027 for ; Sun, 5 Dec 1999 10:39:48 -0500 (EST) (envelope-from jkarlen@karlen.com) Received: from jon (dialup-209.246.68.140.NewYork2.Level3.net [209.246.68.140]) by onyx.he.net (8.8.6/8.8.2) with SMTP id HAA20631 for ; Sun, 5 Dec 1999 07:39:43 -0800 Message-ID: <004801bf3f36$f2104680$94b1f4d1@westnet.com> From: "Jonathan Karlen" To: Subject: Accent Marks Date: Sun, 5 Dec 1999 10:39:39 -0500 Organization: Karlen Internet Solutions MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0045_01BF3F0D.080C1EC0" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.00.2314.1300 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300 This is a multi-part message in MIME format. ------=_NextPart_000_0045_01BF3F0D.080C1EC0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Greetings, I have a a client whom we're building a web application for that = contains data in many languages. What they would like is for queries to = be accent insensitive. In other words, for example in Spanish, if I was = to search on the word "ir", I'd get back any results containing either = "ir" or the same word with the "i" having an accent mark. I don't see = how this is possible. Any advice? Jonathan Karlen ********************************************** Jonathan R. Karlen Karlen Internet Solutions jkarlen@karlen.com www.karlen.com ------=_NextPart_000_0045_01BF3F0D.080C1EC0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Greetings,
 
I have a a client whom we're building a web = application for=20 that contains data in many languages.  What they would like is for = queries=20 to be accent insensitive.  In other words, for example in Spanish, = if I was=20 to search on the word "ir", I'd get back any results = containing either "ir"=20 or the same word with the "i" having an accent mark.  I don't see = how this=20 is possible.  Any advice?
 
Jonathan Karlen
**********************************************
Jonathan R.=20 Karlen
Karlen Internet Solutions
jkarlen@karlen.com
www.karlen.com
------=_NextPart_000_0045_01BF3F0D.080C1EC0-- From tjk@tksoft.com Sun Dec 5 18:26:42 1999 Received: from as.tksoft.com (gyw.com [209.55.67.177] (may be forged)) by hub.org (8.9.3/8.9.3) with ESMTP id NAA48619 for ; Sun, 5 Dec 1999 13:26:42 -0500 (EST) (envelope-from tjk@tksoft.com) Received: (from tjk@tksoft.com) by uno.tksoft.com (8.8.8/8.8.8) id KAA10642; Sun, 5 Dec 1999 10:03:58 -0800 From: "tjk@tksoft.com" Message-Id: <199912051803.KAA10642@uno.tksoft.com> Subject: Re: [SQL] Accent Marks To: jkarlen@karlen.com (Jonathan Karlen) Date: Sun, 5 Dec 1999 10:03:58 -0800 (PST) Cc: pgsql-sql@postgreSQL.org In-Reply-To: <004801bf3f36$f2104680$94b1f4d1@westnet.com> from "Jonathan Karlen" at Dec 5, 99 10:39:39 am Content-Type: text Jonathan, You could write a custom function which handles the searches for you, allowing i and i w/ an accent, for example, to be handled as the same character. When implementing regular expressions, one creates a pattern which can be used for matching against strings. In your situation, you could create a function which takes your string and creates a pattern out of it, or to make things easier, just accept the string as input and convert it to a string which can be converted to a regular expression pattern by Postgres. E.g. you would accept your search string as input, and find all i's in it, replacing them with "[iACCENTEDI]" so that when a search is done, either of the i's qualifies. There are more efficient ways of doing this, but this would probably work for you. Troy > > This is a multi-part message in MIME format. > > ------=_NextPart_000_0045_01BF3F0D.080C1EC0 > Content-Type: text/plain; > charset="iso-8859-1" > Content-Transfer-Encoding: quoted-printable > > Greetings, > > I have a a client whom we're building a web application for that = > contains data in many languages. What they would like is for queries to = > be accent insensitive. In other words, for example in Spanish, if I was = > to search on the word "ir", I'd get back any results containing either = > "ir" or the same word with the "i" having an accent mark. I don't see = > how this is possible. Any advice? > > Jonathan Karlen > ********************************************** > Jonathan R. Karlen > Karlen Internet Solutions > jkarlen@karlen.com > www.karlen.com > > ------=_NextPart_000_0045_01BF3F0D.080C1EC0 > Content-Type: text/html; > charset="iso-8859-1" > Content-Transfer-Encoding: quoted-printable > > > > http-equiv=3DContent-Type> > > > > >
Greetings,
>
 
>
I have a a client whom we're building a web = > application for=20 > that contains data in many languages.  What they would like is for = > queries=20 > to be accent insensitive.  In other words, for example in Spanish, = > if I was=20 > to search on the word "ir", I'd get back any results = > containing either "ir"=20 > or the same word with the "i" having an accent mark.  I don't see = > how this=20 > is possible.  Any advice?
>
 
>
Jonathan Karlen
>
size=3D2>**********************************************
Jonathan R.=20 > Karlen
Karlen Internet Solutions
href=3D"mailto:jkarlen@karlen.com">jkarlen@karlen.com
href=3D"http://www.karlen.com">www.karlen.com
ML> > > ------=_NextPart_000_0045_01BF3F0D.080C1EC0-- > > > ************ > >