Re: Searching for foreign chars

This WebDNA talk-list message is from

2004

It keeps the original formatting. numero = 58855
interpreted = N
texte = Yes, that is what I thought of it first too, but the problem is that the =DBis 200MB of size! Too large to do this kind of games:-)SincerelyNitai--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> Brian Fries> Sent: Thursday, July 22, 2004 6:27 PM> To: WebDNA Talk> Subject: Re: Searching for foreign chars>=20> It sounds like you may have to to a bulk character mapping on the> database in WebDNA after it has been uploaded to the server. If the DB> is not too many MB in size, you should be able to (1) make sure the DB> is closed, then (2) do a [writefile your.db][convertchars> yourmap.db][include your.db][/convertchars][/writefile]>=20> You could do a reverse mapping if the customer wants to later dowload> the DB and import it back into Filemaker.>=20> - brian>=20> On Jul 22, 2004, at 7:46 AM, Nitai @ ComputerOil wrote:>=20> > That might do it, but the point is that we need to accomplish this =in> > one> > step and without 3rd party tools involved. Well, I just keep on> > digging :-)> >> > Thank you.> >> > --> > 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 2:20 PM> >> To: WebDNA Talk> >> Subject: Re: Searching for foreign chars> >>> >> Client could try to open the exported file in BBedit and save as> >> 'Western (ISO Latin 1)' - Options button on save dialog...> >>> >> Might fix it?> >>> >> Yours> >>> >> Philip.> >>> >>> >> On 22 Jul 2004, at 13:43, Nitai @ ComputerOil wrote:> >>> >>> 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> >>>>>> -- Brian Fries, BrainScan Software -- =http://www.brainscansoftware.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:

Re: Searching for foreign chars ( "Nitai @ ComputerOil" 2004)
Re: Searching for foreign chars ( Brian Fries 2004)
Re: Searching for foreign chars ( "Nitai @ ComputerOil" 2004)
Re: Searching for foreign chars ( Philip Edell 2004)
Re: Searching for foreign chars ( "Nitai @ ComputerOil" 2004)
Re: Searching for foreign chars ( Philip Edell 2004)
Re: Searching for foreign chars ( Thierry Almy 2004)
Re: Searching for foreign chars ( "Nitai @ ComputerOil" 2004)
Re: Searching for foreign chars ( "Christopher Feyrer" 2004)
Searching for foreign chars ( "Nitai @ ComputerOil" 2004)

Yes, that is what I thought of it first too, but the problem is that the =DBis 200MB of size! Too large to do this kind of games:-)SincerelyNitai--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> Brian Fries> Sent: Thursday, July 22, 2004 6:27 PM> To: WebDNA Talk> Subject: Re: Searching for foreign chars>=20> It sounds like you may have to to a bulk character mapping on the> database in WebDNA after it has been uploaded to the server. If the DB> is not too many MB in size, you should be able to (1) make sure the DB> is closed, then (2) do a [writefile your.db][convertchars> yourmap.db][include your.db][/convertchars][/writefile]>=20> You could do a reverse mapping if the customer wants to later dowload> the DB and import it back into Filemaker.>=20> - brian>=20> On Jul 22, 2004, at 7:46 AM, Nitai @ ComputerOil wrote:>=20> > That might do it, but the point is that we need to accomplish this =in> > one> > step and without 3rd party tools involved. Well, I just keep on> > digging :-)> >> > Thank you.> >> > --> > 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 2:20 PM> >> To: WebDNA Talk> >> Subject: Re: Searching for foreign chars> >>> >> Client could try to open the exported file in BBedit and save as> >> 'Western (ISO Latin 1)' - Options button on save dialog...> >>> >> Might fix it?> >>> >> Yours> >>> >> Philip.> >>> >>> >> On 22 Jul 2004, at 13:43, Nitai @ ComputerOil wrote:> >>> >>> 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> >>>>>> -- Brian Fries, BrainScan Software -- =http://www.brainscansoftware.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!

Re: Searching for foreign chars

2004

Top Articles:

Related Readings: