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:
WebCatalog for guestbook ? (1997)
[ShowNext] (1997)
[WebDNA] Dynamic vertical columns (2008)
Re:PCS Customer submissions ? (1997)
[OT] Weird Characters (2004)
WebCat2b13MacPlugIn - [showif][search][/showif] (1997)
Re[2]: Next X hits (1996)
[REPLACE] inside [FOUNDITEMS] (1998)
Date Time Oddness (1999)
Sendmail html/text and CCS problem (2003)
Install Webcatalog under NT4.0 and Microsoft IIS 2.0 (1997)
Title not showing up in ViewOrder template (1998)
Getting Emailer to send mail (1997)
HMAC-MD5 hash -- what the... (2003)
[LOOKUP] (1997)
Sorry, WebDNA Server Not Running! (2005)
Auto Submit (2000)
Privacy Issue (LEGIT QUESTION) (2003)
ShowIf Question (1998)
Re:WebCatalog/WebMerchant III (1998)