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:

autosensing lanague selection (1997) Remote delivery (1998) Updating fields from different platforms (1998) [WebDNA] ONLY the FIRST continuous run of numeric chars? (2008) Can you do this??? and other stuff (1997) Suggestions for Topics to be covered in an Advanced WebDNACourse... (1998) RE: Languages (1997) HELP! 10K hits per hour for pages that no longer exist! (2000) [WebDNA] WebDNA Alive! (2012) Webcat/Webmerchant (1998) Sorting when searching with grouped fields (2002) WebCat for Unix?? (1997) RAM variables (1997) 2.0Beta Command Ref (can't find this instruction) (1997) Separate SSL Server (1997) test (2000) Cart Unique After Rolling Back Time? (2001) Another [redirect] question (2003) Too Much Rootbeer Free Offer (1997) TCP Connect/send and CGI (2003)