RE: [WebDNA] Foreign characters (2009)
This WebDNA talk-list message is from 2009
It keeps the original formatting.
numero = 102326
interpreted = N
texte = > I guess you will have to look into a word conversion list as I suggested.(as apposed to a character conversion listWhat about creating a new field in your database that mirrors your livecontent that contains NO accented characters? Then when you have a search,strip out all accented characters from the search then search on themirrored field instead? That way, you should be able to find all content.Should be easy to set this up. Batch update existing content. Add code fornew content and edited content to keep the mirrored (and hidden) fieldupdated. Use the same function to strip away all accents.Another approach is to keep the mirrored, accentless field updated and thendo a multifield search without changing any user input. If a user types inaccents, it should match the accented field. No accents, a match should hitfor the accentless field.
Associated Messages, from the most recent to the oldest:
> I guess you will have to look into a word conversion list as I suggested.(as apposed to a character conversion listWhat about creating a new field in your database that mirrors your livecontent that contains NO accented characters? Then when you have a search,strip out all accented characters from the search then search on themirrored field instead? That way, you should be able to find all content.Should be easy to set this up. Batch update existing content. Add code fornew content and edited content to keep the mirrored (and hidden) fieldupdated. Use the same function to strip away all accents.Another approach is to keep the mirrored, accentless field updated and thendo a multifield search without changing any user input. If a user types inaccents, it should match the accented field. No accents, a match should hitfor the accentless field.
"Olin Lagon"
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:
hiding hyperlink info in URL field (1999)
WebCat2b12 CGI Mac - [shownext] problem (1997)
2 questions (2000)
all records returned. (1997)
WebCatalog can't find database (1997)
What is WebDNA (1997)
Question... (2002)
Convert "&" to "&" using [grep] (2006)
Visitor info (2000)
Unix line endings (2003)
Limit on nested [ShowIf]'s? (1997)
carriage returns in data (1997)
[encrypt] blues.... (2000)
Protecting Images (2003)
Showif date > other date (2004)
Assigning carts (1998)
how do you and/or in a search? (1997)
How to append text after the sign & (1997)
Comments in db? (1997)
License (2003)