Re: [WebDNA] Foreign characters (2009)

This WebDNA talk-list message is from

2009


It keeps the original formatting.
numero = 102309
interpreted = N
texte = christophe.billiottet@webdna.us wrote: > I guess it will depend on your encoding, but a table like this should help: > > > [table name=t1&fields=from,to] > é e > è e > ê e > ë e > û u > ù u > ü u > î i > í i > ï i > ó o > ü u > Ú U > Ó O > Í I > ñ n > Ñ N > É E > È E > ç c > à a > Á A > à a > á a > Ê E > À A > [/table] > > Then, when you search your café, [Search db=base.db&woNAMEdata=café > [convertchars table=t1]café[/convertchars]].... > > It will search for "café" or "cafe" > > - chris That may be a good approach, but in the posters example, it was the other way around. So, you'd have to switch the characters.. fromto AÀ for example. It would depend on what format your data was in as to which "way" the conversion should take place... but I like the solution Chris! Donovan -- Donovan D. Brooke PH: 1 (608) 770-3822 ------------------------------------------------ VP WebDNA Software Corporation 16192 Coastal Highway Lewes, DE 19958 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)
christophe.billiottet@webdna.us wrote: > I guess it will depend on your encoding, but a table like this should help: > > > [table name=t1&fields=from,to] > é e > è e > ê e > ë e > û u > ù u > ü u > î i > í i > ï i > ó o > ü u > Ú U > Ó O > Í I > ñ n > Ñ N > É E > È E > ç c > à a > Á A > à a > á a > Ê E > À A > [/table] > > Then, when you search your café, [Search db=base.db&woNAMEdata=café > [convertchars table=t1]café[/convertchars]].... > > It will search for "café" or "cafe" > > - chris That may be a good approach, but in the posters example, it was the other way around. So, you'd have to switch the characters.. fromto AÀ for example. It would depend on what format your data was in as to which "way" the conversion should take place... but I like the solution Chris! Donovan -- Donovan D. Brooke PH: 1 (608) 770-3822 ------------------------------------------------ VP WebDNA Software Corporation 16192 Coastal Highway Lewes, DE 19958 Donovan Brooke

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:

Further on formula.db failure to calculate shipCost (1997) relogin same user? (1998) WriteFile (2000) all records returned. (1997) -REPOST- WebCat 3 & Aliases (2000) POST (1997) WC2b15 File Corruption (1997) [isfolder] and [filename] (1997) [TaxableTotal] - not working with AOL and IE (1997) OIT Firewall for Windows 2000 Server (2005) creating a ShipCosts database (1997) Problems with [Applescript] (1997) Menu to select product variations (1997) [SearchString] problem with [search] context (1997) WC2/Mac -- Forms not submitting correctly with Mac browsers (1997) Monthly Reports (2000) webcat license???? (1997) Search for starts with and ends with? (2003) Server crash (1997) Quickie question on the email templates (1997)