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 =originalquestion :-)The data is NOT coming from a form into a DB, it is coming from =FileMakerProwhen doing an export. If I go further the customer exports the FMP on =hisApple Powerbook, then uploads the db to our MacOS X Server and thenmanipulates the data with a Windows or whatever platform Browser again.After that the customer might want to import the data again into hisFileMaker db and export it again and and and.......But I am getting there slowly :-)Nitai--Redakto - Content Management that simply worksContent Management & eBusiness Systems=20ComputerOil=AE AGDammstrasse 75400 Baden / SwitzerlandTelefon +41 (0)844 44 55 66=20info@computeroil.comhttp://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:
Hi Philip,Thank you for your answer, but so far everybody has gone passed the =originalquestion :-)The data is NOT coming from a form into a DB, it is coming from =FileMakerProwhen doing an export. If I go further the customer exports the FMP on =hisApple Powerbook, then uploads the db to our MacOS X Server and thenmanipulates the data with a Windows or whatever platform Browser again.After that the customer might want to import the data again into hisFileMaker db and export it again and and and.......But I am getting there slowly :-)Nitai--Redakto - Content Management that simply worksContent Management & eBusiness Systems=20ComputerOil=AE AGDammstrasse 75400 Baden / SwitzerlandTelefon +41 (0)844 44 55 66=20info@computeroil.comhttp://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)