Re: Searching for foreign chars
This WebDNA talk-list message is from 2004
It keeps the original formatting.
numero = 58851
interpreted = N
texte = That might do it, but the point is that we need to accomplish this in =onestep and without 3rd party tools involved. Well, I just keep on digging =:-)Thank you.--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 2:20 PM> To: WebDNA Talk> Subject: Re: Searching for foreign chars>=20> Client could try to open the exported file in BBedit and save as> 'Western (ISO Latin 1)' - Options button on save dialog...>=20> Might fix it?>=20> Yours>=20> Philip.>=20>=20> On 22 Jul 2004, at 13:43, Nitai @ ComputerOil wrote:>=20> > 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> >> > ComputerOil=AE AG> > Dammstrasse 7> > 5400 Baden / Switzerland> > Telefon +41 (0)844 44 55 66> >> > 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> >>> >> 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> >> containing accented characters work fine.> >>> >> So for example: Stiftung Matthias K=FChn in the db is> >> Stiftung%20Matthias%20K%FChn> >>> >> Then use a search like [search> >> 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> >> 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> >>> =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/> >>>> >>> >>> >> -------------------------------------------------------------> >> 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/> >>=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:
That might do it, but the point is that we need to accomplish this in =onestep and without 3rd party tools involved. Well, I just keep on digging =:-)Thank you.--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 2:20 PM> To: WebDNA Talk> Subject: Re: Searching for foreign chars>=20> Client could try to open the exported file in BBedit and save as> 'Western (ISO Latin 1)' - Options button on save dialog...>=20> Might fix it?>=20> Yours>=20> Philip.>=20>=20> On 22 Jul 2004, at 13:43, Nitai @ ComputerOil wrote:>=20> > 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> >> > ComputerOil=AE AG> > Dammstrasse 7> > 5400 Baden / Switzerland> > Telefon +41 (0)844 44 55 66> >> > 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> >>> >> 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> >> containing accented characters work fine.> >>> >> So for example: Stiftung Matthias K=FChn in the db is> >> Stiftung%20Matthias%20K%FChn> >>> >> Then use a search like [search> >> 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> >> 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> >>> =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/> >>>> >>> >>> >> -------------------------------------------------------------> >> 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/> >>=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:
Searching multiple fields (1997)
Bug? (1997)
WC Bulletin Board Issue (2003)
WCS Newbie question (1997)
[WebDNA] [jobposting] C++ Programmer (2008)
Re:2nd WebCatalog2 Feature Request (1996)
Frames and WebCat (1997)
Change extension (2000)
Getting Emailer to send mail (1997)
Cookie Question (1999)
[protect admin] (1997)
transferring values (1998)
itools webcat atartup (2000)
Add a field to the error log? (1997)
Major bug report on rootbeer (1997)
Help formatting search results w/ table (1997)
Orders.db problem (2003)
Mac app. that converts e-mails (2000)
catching WebDNA error messages (2003)
Another question (1997)