Re: Searching for foreign chars
This WebDNA talk-list message is from 2004
It keeps the original formatting.
numero = 58844
interpreted = N
texte = 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=20containing accented characters work fine.So for example: Stiftung Matthias K=FChn in the db is=20Stiftung%20Matthias%20K%FChnThen use a search like [search=20db=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=20collecting form data is addaccept-charset=3D"ISO-8859-1" to the form tag.Hope that helps.YoursPhilipOn 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=20> =93=E4=94,> =93=F6=94, or =93=FC=94 (yes, those German umlauts), the search =returns no=20> results. But> if I append a record with those umlauts and then search for them it=20> works.>> I know this is not a big thing, but maybe someone can get me on the=20> 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> =A0> ComputerOil=AE AG> Dammstrasse 7> 5400 Baden / Switzerland> Telefon +41 (0)844 44 55 66> =A0> 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=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:
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=20containing accented characters work fine.So for example: Stiftung Matthias K=FChn in the db is=20Stiftung%20Matthias%20K%FChnThen use a search like [search=20db=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=20collecting form data is addaccept-charset=3D"ISO-8859-1" to the form tag.Hope that helps.YoursPhilipOn 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=20> =93=E4=94,> =93=F6=94, or =93=FC=94 (yes, those German umlauts), the search =returns no=20> results. But> if I append a record with those umlauts and then search for them it=20> works.>> I know this is not a big thing, but maybe someone can get me on the=20> 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> =A0> ComputerOil=AE AG> Dammstrasse 7> 5400 Baden / Switzerland> Telefon +41 (0)844 44 55 66> =A0> 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=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:
autosensing lanague selection (1997)
Remote delivery (1998)
Updating fields from different platforms (1998)
[WebDNA] ONLY the FIRST continuous run of numeric chars? (2008)
Can you do this??? and other stuff (1997)
Suggestions for Topics to be covered in an Advanced WebDNACourse... (1998)
RE: Languages (1997)
HELP! 10K hits per hour for pages that no longer exist! (2000)
[WebDNA] WebDNA Alive! (2012)
Webcat/Webmerchant (1998)
Sorting when searching with grouped fields (2002)
WebCat for Unix?? (1997)
RAM variables (1997)
2.0Beta Command Ref (can't find this instruction) (1997)
Separate SSL Server (1997)
test (2000)
Cart Unique After Rolling Back Time? (2001)
Another [redirect] question (2003)
Too Much Rootbeer Free Offer (1997)
TCP Connect/send and CGI (2003)