Re: Searching for foreign chars
This WebDNA talk-list message is from 2004
It keeps the original formatting.
numero = 58848
interpreted = N
texte = Client could try to open the exported file in BBedit and save as=20 '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=20 > original > question :-) > > The data is NOT coming from a form into a DB, it is coming from=20 > FileMakerPro > when doing an export. If I go further the customer exports the FMP on=20= > 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=20= >> 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=FCh= n]) >> >> 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=20= >>> 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=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:
Client could try to open the exported file in BBedit and save as=20 '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=20 > original > question :-) > > The data is NOT coming from a form into a DB, it is coming from=20 > FileMakerPro > when doing an export. If I go further the customer exports the FMP on=20= > 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=20= >> 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=FCh= n]) >> >> 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=20= >>> 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=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:
WebCat2b13MacPlugIn - [include] doesn't allow creator (1997)
OT: advice on Wintel server options (1998)
Mac GUI editors (1997)
For you expert WebDNA coders (was Interesting speed (2003)
taxTotal, too (1997)
Refering page (1998)
[WebDNA] Cookies & localhost (2008)
5.1: Can't enter serial number (2004)
WebCat2b12 - nesting [tags] (1997)
Re:multiple digests, please stop (1997)
math a various prices (1997)
createfolder not behaving as expected (1999)
Really need a answer (1999)
More on the email templates (1997)
select multiple 2 more cents (1997)
Sku numbers (1997)
unable to launch acgi in WebCat (1997)
Problem with broken images (2004)
[TaxableTotal] - not working with AOL and IE (1997)
Nested tags count question (1997)