Re: [WebDNA] Foreign characters (2009)

This WebDNA talk-list message is from

2009


It keeps the original formatting.
numero = 102332
interpreted = N
texte = Olin Lagon wrote: > What about creating a new field in your database that mirrors your live > content that contains NO accented characters? That's what I've been doing at it works fine although of course it=20 increases the size of the databases considerably. The idea can also be=20 expanded to deal with other kinds of close-match searches. The main problem back in 1998 was the lack of a standard extended=20 character set. At that time "caf=E9" might have come across as "caf=FF,"=20 "caf=EE" or whatever, depending on what OS/OS version/software the=20 visitor's computer was running. This is no longer a major concern and=20 that makes the problem much easier to solve. A wildcard search function would have made it even easier. No need for=20 complicated conversion tables for the input string, just replace all=20 potentially tricky charcaters with a * and do a wildcard enabled search=20 through the simplified-charcters database field. (I can think of several=20 other practical uses for wildcard searches as well. Would it be hard to=20 persuade Donovan & co to include it in the next WebDNA upgrade?) Frank Nordberg http://www.musicaviva.com http://stores.ebay.com/Nordbergs-Music-Store?refid=3Dstore Associated Messages, from the most recent to the oldest:

    
  1. Re: [WebDNA] Foreign characters (2009) (Frank Nordberg 2009)
  2. Re: [WebDNA] Foreign characters (2009) (Patrick McCormick 2009)
  3. RE: [WebDNA] Foreign characters (2009) ("Olin Lagon" 2009)
  4. Re: [WebDNA] Foreign characters (2009) (christophe.billiottet@webdna.us 2009)
  5. Re: [WebDNA] Foreign characters (2009) (Donovan Brooke 2009)
  6. Re: [WebDNA] Foreign characters (2009) (=?ISO-8859-1?Q?Cristi=E1n_Tapia?= 2009)
  7. Re: [WebDNA] Foreign characters (2009) (Frank Nordberg 2009)
  8. Re: [WebDNA] Foreign characters (2009) (Donovan Brooke 2009)
  9. Re: [WebDNA] Foreign characters (2009) (Patrick McCormick 2009)
  10. Re: [WebDNA] Foreign characters (2009) (Donovan Brooke 2009)
  11. Re: [WebDNA] Foreign characters (2009) (christophe.billiottet@webdna.us 2009)
  12. Re: [WebDNA] Foreign characters (2009) ("Dan Strong" 2009)
  13. Re: [WebDNA] Foreign characters (2009) (Donovan Brooke 2009)
  14. Re: [WebDNA] Foreign characters (2009) (Tom Duke 2009)
  15. Re: [WebDNA] Foreign characters (2009) ("Dan Strong" 2009)
  16. [WebDNA] Foreign characters (2009) (=?ISO-8859-1?Q?Cristi=E1n_Tapia?= 2009)
Olin Lagon wrote: > What about creating a new field in your database that mirrors your live > content that contains NO accented characters? That's what I've been doing at it works fine although of course it=20 increases the size of the databases considerably. The idea can also be=20 expanded to deal with other kinds of close-match searches. The main problem back in 1998 was the lack of a standard extended=20 character set. At that time "caf=E9" might have come across as "caf=FF,"=20 "caf=EE" or whatever, depending on what OS/OS version/software the=20 visitor's computer was running. This is no longer a major concern and=20 that makes the problem much easier to solve. A wildcard search function would have made it even easier. No need for=20 complicated conversion tables for the input string, just replace all=20 potentially tricky charcaters with a * and do a wildcard enabled search=20 through the simplified-charcters database field. (I can think of several=20 other practical uses for wildcard searches as well. Would it be hard to=20 persuade Donovan & co to include it in the next WebDNA upgrade?) Frank Nordberg http://www.musicaviva.com http://stores.ebay.com/Nordbergs-Music-Store?refid=3Dstore Frank Nordberg

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:

Searching multiple fields (1997) [WebDNA] [BULK] Mac OS X LION has no FastCGI (2011) numfound question (2005) Java Path Follow Up (2004) Emailer choke (1997) [showif],[referrer],[include] in errormessages.db (2002) Setting up the server (1997) WebCatalog for Postcards ? (1997) WebDNA and SQL (2003) Sub Totals (2000) OK, here goes... (1997) Appending space (1998) TCP not connecting to Authnet (2004) Preventing code execution (2003) WebCatalog dying in WebTen Revisited (1998) RE: Answer: WebDelivery downloads alias, not original ? (1997) [OT] Form POSTing with LONG variable (2007) Removing [showif] makes a big difference in speed (1997) AutoCommit Preference? (1998) RE: Problems with dbcatalog.exe (1997)