Re: Searching for foreign chars

This WebDNA talk-list message is from

2004


It keeps the original formatting.
numero = 58844
interpreted = N
texte = Hi Nitai, I work in Spanish, German, and English and had to solve this one too. I [URL] wrap all data before it goes into a db, then the searches=20 containing accented characters work fine. So for example: Stiftung Matthias K=FChn in the db is=20 Stiftung%20Matthias%20K%FChn Then use a search like [search=20 db=3D[db]text.db&geFIELDdatarq=3D[url]K=FChn[/url]] (It also works if you do [search db=3D[db]text.db&geFIELDdatarq=3DK=FChn])= Obviously UnURL the founditems. Although not related to your question another thing I do whenever=20 collecting form data is add accept-charset=3D"ISO-8859-1" to the form tag. Hope that helps. Yours Philip On 21 Jul 2004, at 22:54, Nitai @ ComputerOil wrote: > Hi all, > > I am having a problem with a database from a customer which exports = his > records from FileMaker. > > Problem is that when I search from a form within the database for a=20 > =93=E4=94, > =93=F6=94, or =93=FC=94 (yes, those German umlauts), the search = returns no=20 > results. But > if I append a record with those umlauts and then search for them it=20 > works. > > I know this is not a big thing, but maybe someone can get me on the=20 > right > track. Somehow today my brain is just not working the way I want=85.. > > Thank you all in advance. > > Nitai > > -- > Redakto - Content Management that simply works > Content Management & eBusiness Systems > =A0 > ComputerOil=AE AG > Dammstrasse 7 > 5400 Baden / Switzerland > Telefon +41 (0)844 44 55 66 > =A0 > info@computeroil.com > http://computeroil.com > > > > > > ------------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > To switch to the DIGEST mode, E-mail to=20 > > Web Archive of this list is at: http://webdna.smithmicro.com/ > ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: Searching for foreign chars ( "Nitai @ ComputerOil" 2004)
  2. Re: Searching for foreign chars ( Brian Fries 2004)
  3. Re: Searching for foreign chars ( "Nitai @ ComputerOil" 2004)
  4. Re: Searching for foreign chars ( Philip Edell 2004)
  5. Re: Searching for foreign chars ( "Nitai @ ComputerOil" 2004)
  6. Re: Searching for foreign chars ( Philip Edell 2004)
  7. Re: Searching for foreign chars ( Thierry Almy 2004)
  8. Re: Searching for foreign chars ( "Nitai @ ComputerOil" 2004)
  9. Re: Searching for foreign chars ( "Christopher Feyrer" 2004)
  10. Searching for foreign chars ( "Nitai @ ComputerOil" 2004)
Hi Nitai, I work in Spanish, German, and English and had to solve this one too. I [url] wrap all data before it goes into a db, then the searches=20 containing accented characters work fine. So for example: Stiftung Matthias K=FChn in the db is=20 Stiftung%20Matthias%20K%FChn Then use a search like [search=20 db=3D[db]text.db&geFIELDdatarq=3D[url]K=FChn[/url]] (It also works if you do [search db=3D[db]text.db&geFIELDdatarq=3DK=FChn])= Obviously UnURL the founditems. Although not related to your question another thing I do whenever=20 collecting form data is add accept-charset=3D"ISO-8859-1" to the form tag. Hope that helps. Yours Philip On 21 Jul 2004, at 22:54, Nitai @ ComputerOil wrote: > Hi all, > > I am having a problem with a database from a customer which exports = his > records from FileMaker. > > Problem is that when I search from a form within the database for a=20 > =93=E4=94, > =93=F6=94, or =93=FC=94 (yes, those German umlauts), the search = returns no=20 > results. But > if I append a record with those umlauts and then search for them it=20 > works. > > I know this is not a big thing, but maybe someone can get me on the=20 > right > track. Somehow today my brain is just not working the way I want=85.. > > Thank you all in advance. > > Nitai > > -- > Redakto - Content Management that simply works > Content Management & eBusiness Systems > =A0 > ComputerOil=AE AG > Dammstrasse 7 > 5400 Baden / Switzerland > Telefon +41 (0)844 44 55 66 > =A0 > info@computeroil.com > http://computeroil.com > > > > > > ------------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > To switch to the DIGEST mode, E-mail to=20 > > Web Archive of this list is at: http://webdna.smithmicro.com/ > ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/ Philip Edell

DOWNLOAD WEBDNA NOW!

Top Articles:

Talk List

The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...

Related Readings:

WebCatalog for guestbook ? (1997) [ShowNext] (1997) [WebDNA] Dynamic vertical columns (2008) Re:PCS Customer submissions ? (1997) [OT] Weird Characters (2004) WebCat2b13MacPlugIn - [showif][search][/showif] (1997) Re[2]: Next X hits (1996) [REPLACE] inside [FOUNDITEMS] (1998) Date Time Oddness (1999) Sendmail html/text and CCS problem (2003) Install Webcatalog under NT4.0 and Microsoft IIS 2.0 (1997) Title not showing up in ViewOrder template (1998) Getting Emailer to send mail (1997) HMAC-MD5 hash -- what the... (2003) [LOOKUP] (1997) Sorry, WebDNA Server Not Running! (2005) Auto Submit (2000) Privacy Issue (LEGIT QUESTION) (2003) ShowIf Question (1998) Re:WebCatalog/WebMerchant III (1998)