Re: Searching for foreign chars
This WebDNA talk-list message is from 2004
It keeps the original formatting.
numero = 58854
interpreted = N
texte = It sounds like you may have to to a bulk character mapping on the=20 database in WebDNA after it has been uploaded to the server. If the DB=20= is not too many MB in size, you should be able to (1) make sure the DB=20= is closed, then (2) do a [writefile your.db][convertchars=20 yourmap.db][include your.db][/convertchars][/writefile] You could do a reverse mapping if the customer wants to later dowload=20 the DB and import it back into Filemaker. - brian On Jul 22, 2004, at 7:46 AM, Nitai @ ComputerOil wrote: > That might do it, but the point is that we need to accomplish this in=20= > one > step and without 3rd party tools involved. Well, I just keep on=20 > 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=20= >> 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=20 >>> 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=20 >>>> 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= -- ------------------------------------------------------------- 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:
It sounds like you may have to to a bulk character mapping on the=20 database in WebDNA after it has been uploaded to the server. If the DB=20= is not too many MB in size, you should be able to (1) make sure the DB=20= is closed, then (2) do a [writefile your.db][convertchars=20 yourmap.db][include your.db][/convertchars][/writefile] You could do a reverse mapping if the customer wants to later dowload=20 the DB and import it back into Filemaker. - brian On Jul 22, 2004, at 7:46 AM, Nitai @ ComputerOil wrote: > That might do it, but the point is that we need to accomplish this in=20= > one > step and without 3rd party tools involved. Well, I just keep on=20 > 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=20= >> 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=20 >>> 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=20 >>>> 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= -- ------------------------------------------------------------- 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/
Brian Fries
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:
WebCat & WebTen (1997)
SQL Changes in 3.0.7? (2000)
[WebDNA] WebDNA is not parsing CSS file (2010)
waitforfile then redirect (2001)
Satisfy Me ! was: Why can't support be satisfying to purchasers? (2000)
WebCat2: Formulas.db question (1997)
SiteEdit NewFile.html ? (1997)
[WebDNA] Serial numbers and pricing for WebDNA 7.0 (2011)
How do I pass [cart] when user clicks back (2000)
Date Sorting (1997)
Not sending email !!! (2002)
How to implement 'email to a friend' feature? (2002)
updating with ProductEditor (1998)
Custom Error Pages - what I've done (1998)
Date format problems (1997)
color and size options (1997)
Dealing with da back button (1999)
Possible Bug in 2.0b15.acgi (1997)
[OT] Robust order processing (2003)
'does not contain' operator needed ... (1997)