Re: Searching for foreign chars

This WebDNA talk-list message is from

2004

It keeps the original formatting. numero = 58841
interpreted = N
texte = I don=92t think need to use convertchars when searching IN fields from a =form.There is no problem when the data is in the database when the data isappended from a form into the db.Problem occurs only when the data is coming from FileMaker. We have alsotried to export the DB in different charsets like ASCII, WindowsANSI,Unicode, etc. Still no success.Nitai--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> Christopher Feyrer> Sent: Wednesday, July 21, 2004 10:56 PM> To: WebDNA Talk> Subject: Re: Searching for foreign chars>=20> Try using [convertchars]. Also, try exporting the database tab =delimited> as type "merge", then clean the text with a text manipulation tool =like> TextPad or BBEdit.>=20> -----Original Message-----> From: WebDNA Talk [mailto:WebDNA-Talk@talk.smithmicro.com] On Behalf =Of> Nitai @ ComputerOil> Sent: Wednesday, July 21, 2004 3:54 PM> To: WebDNA Talk> Subject: Searching for foreign chars>=20> Hi all,>=20> I am having a problem with a database from a customer which exports =his> records from FileMaker.>=20> Problem is that when I search from a form within the database for a ="=E4",> "=F6", or "=FC" (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.>=20> 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.....>=20> Thank you all in advance.>=20> Nitai>=20> --> Redakto - Content Management that simply works> Content Management & eBusiness Systems>=20> ComputerOil=AE AG> Dammstrasse 7> 5400 Baden / Switzerland> Telefon +41 (0)844 44 55 66>=20> info@computeroil.com> http://computeroil.com>=20>=20>=20>=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/>=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)

I don=92t think need to use convertchars when searching IN fields from a =form.There is no problem when the data is in the database when the data isappended from a form into the db.Problem occurs only when the data is coming from FileMaker. We have alsotried to export the DB in different charsets like ASCII, WindowsANSI,Unicode, etc. Still no success.Nitai--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> Christopher Feyrer> Sent: Wednesday, July 21, 2004 10:56 PM> To: WebDNA Talk> Subject: Re: Searching for foreign chars>=20> Try using [convertchars]. Also, try exporting the database tab =delimited> as type "merge", then clean the text with a text manipulation tool =like> TextPad or BBEdit.>=20> -----Original Message-----> From: WebDNA Talk [mailto:WebDNA-Talk@talk.smithmicro.com] On Behalf =Of> Nitai @ ComputerOil> Sent: Wednesday, July 21, 2004 3:54 PM> To: WebDNA Talk> Subject: Searching for foreign chars>=20> Hi all,>=20> I am having a problem with a database from a customer which exports =his> records from FileMaker.>=20> Problem is that when I search from a form within the database for a ="=E4",> "=F6", or "=FC" (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.>=20> 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.....>=20> Thank you all in advance.>=20> Nitai>=20> --> Redakto - Content Management that simply works> Content Management & eBusiness Systems>=20> ComputerOil=AE AG> Dammstrasse 7> 5400 Baden / Switzerland> Telefon +41 (0)844 44 55 66>=20> info@computeroil.com> http://computeroil.com>=20>=20>=20>=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/>=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!

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:

different ship dates and shopping carts -- how to? (1997) 4D Database (1997) Bug Report, maybe (1997) Moving files from one server to another... (2001) Database multiple selections (1998) RE: [REPLACE] inside [FOUNDITEMS] (1998) 3rd party processor question (2003) Searchable archives gone again??? (2000) Web Logs (1998) [WebDNA] Ubuntu 16.04.4 LTS (2018) color and size options / ARCHIVES (1997) Converting characters to numbers ... (1997) emailer (1997) PSC recommends what date format yr 2000??? (1997) Ship via options price (2000) Running 2 two WebCatalog.acgi's (1996) Don't know if this is a sily question... (2003) AOL refuses some e-mails (2000) send mail problem? (1997) taxTotal, grandTotal (1997)