Re: Searching for foreign chars

This WebDNA talk-list message is from

2004


It keeps the original formatting.
numero = 58846
interpreted = N
texte = Hi Philip, Thank you for your answer, but so far everybody has gone passed the = original question :-) The data is NOT coming from a form into a DB, it is coming from = FileMakerPro when doing an export. If I go further the customer exports the FMP on = his Apple Powerbook, then uploads the db to our MacOS X Server and then manipulates the data with a Windows or whatever platform Browser again. After that the customer might want to import the data again into his FileMaker db and export it again and and and....... But I am getting there slowly :-) Nitai -- Redakto - Content Management that simply works Content Management & eBusiness Systems =20 ComputerOil=AE AG Dammstrasse 7 5400 Baden / Switzerland Telefon +41 (0)844 44 55 66 =20 info@computeroil.com http://computeroil.com > -----Original Message----- > From: WebDNA Talk [mailto:WebDNA-Talk@talk.smithmicro.com] On Behalf = Of > Philip Edell > Sent: Thursday, July 22, 2004 1:16 PM > To: WebDNA Talk > Subject: Re: Searching for foreign chars >=20 > Hi Nitai, >=20 > I work in Spanish, German, and English and had to solve this one too. >=20 > I [URL] wrap all data before it goes into a db, then the searches > containing accented characters work fine. >=20 > So for example: Stiftung Matthias K=FChn in the db is > Stiftung%20Matthias%20K%FChn >=20 > Then use a search like [search > db=3D[db]text.db&geFIELDdatarq=3D[url]K=FChn[/url]] >=20 > (It also works if you do [search = db=3D[db]text.db&geFIELDdatarq=3DK=FChn]) >=20 > Obviously UnURL the founditems. >=20 > Although not related to your question another thing I do whenever > collecting form data is add >=20 > accept-charset=3D"ISO-8859-1" to the form tag. >=20 > Hope that helps. >=20 > Yours >=20 > Philip >=20 > On 21 Jul 2004, at 22:54, Nitai @ ComputerOil wrote: >=20 > > 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 > > =93=E4=94, > > =93=F6=94, or =93=FC=94 (yes, those German umlauts), the search = returns no > > results. But > > if I append a record with those umlauts and then search for them it > > works. > > > > I know this is not a big thing, but maybe someone can get me on the > > 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 > > > > ComputerOil=AE AG > > Dammstrasse 7 > > 5400 Baden / Switzerland > > Telefon +41 (0)844 44 55 66 > > > > 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 > > > > Web Archive of this list is at: http://webdna.smithmicro.com/ > > >=20 >=20 > ------------------------------------------------------------- > 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 digest@talk.smithmicro.com> > 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 Philip, Thank you for your answer, but so far everybody has gone passed the = original question :-) The data is NOT coming from a form into a DB, it is coming from = FileMakerPro when doing an export. If I go further the customer exports the FMP on = his Apple Powerbook, then uploads the db to our MacOS X Server and then manipulates the data with a Windows or whatever platform Browser again. After that the customer might want to import the data again into his FileMaker db and export it again and and and....... But I am getting there slowly :-) Nitai -- Redakto - Content Management that simply works Content Management & eBusiness Systems =20 ComputerOil=AE AG Dammstrasse 7 5400 Baden / Switzerland Telefon +41 (0)844 44 55 66 =20 info@computeroil.com http://computeroil.com > -----Original Message----- > From: WebDNA Talk [mailto:WebDNA-Talk@talk.smithmicro.com] On Behalf = Of > Philip Edell > Sent: Thursday, July 22, 2004 1:16 PM > To: WebDNA Talk > Subject: Re: Searching for foreign chars >=20 > Hi Nitai, >=20 > I work in Spanish, German, and English and had to solve this one too. >=20 > I [url] wrap all data before it goes into a db, then the searches > containing accented characters work fine. >=20 > So for example: Stiftung Matthias K=FChn in the db is > Stiftung%20Matthias%20K%FChn >=20 > Then use a search like [search > db=3D[db]text.db&geFIELDdatarq=3D[url]K=FChn[/url]] >=20 > (It also works if you do [search = db=3D[db]text.db&geFIELDdatarq=3DK=FChn]) >=20 > Obviously UnURL the founditems. >=20 > Although not related to your question another thing I do whenever > collecting form data is add >=20 > accept-charset=3D"ISO-8859-1" to the form tag. >=20 > Hope that helps. >=20 > Yours >=20 > Philip >=20 > On 21 Jul 2004, at 22:54, Nitai @ ComputerOil wrote: >=20 > > 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 > > =93=E4=94, > > =93=F6=94, or =93=FC=94 (yes, those German umlauts), the search = returns no > > results. But > > if I append a record with those umlauts and then search for them it > > works. > > > > I know this is not a big thing, but maybe someone can get me on the > > 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 > > > > ComputerOil=AE AG > > Dammstrasse 7 > > 5400 Baden / Switzerland > > Telefon +41 (0)844 44 55 66 > > > > 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 > > > > Web Archive of this list is at: http://webdna.smithmicro.com/ > > >=20 >=20 > ------------------------------------------------------------- > 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 digest@talk.smithmicro.com> > 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/ "Nitai @ ComputerOil"

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:

[WebDNA] WebDNA staging server (2008) WebCatalog NT beta 18 problem (1997) Email within tmpl ? (1997) Candle Light Vigil (2001) A quickie question (1997) Revisit: speed test (2002) problems with 2 tags shakur (1997) A Global Variable (1997) trouble updating records in database (1998) Forms Search Questions (1997) Dr.Watson Error (1999) Public beta 2 for WebCatalog 4.0 is now available. (2000) Speed Admin? (Was FlushDatabases) (1997) format crash! (1997) Drop Down Menus (2002) browser info.txt and SSL (1997) What am I missing (1997) WCS Newbie question (1997) lookup and two records? (1997) Multiple security dbs (1997)