Re: [WebDNA] Foreign characters (2009)
This WebDNA talk-list message is from 2009
It keeps the original formatting.
numero = 102312
interpreted = N
texte = Dan Strong wrote:> [url][/url]?That won't work since "e" and "=E9" will still be different=20chracters/chracter strings after [url].There are two ways to solve this.The best solution is probably to treat all tricky characters as=20wildcards. Problem is, I'm not sure if it's possible to do wildcard=20searches with WebDNA.The other solution is to use a table of all the tricky characters and=20which ones they should be replaced with. This wasn't really an option=20back in '98 with all the different ascii extensions in use at that time.=20But today all modern computers use Unicode which make this solution much=20easier to apply.Of course, ideally this character conversion feature sould be built in=20to WebDNA. Definitely something to add to the wish list for the next=20upgrade. In the meantime it shouldn't be that difficult to script.I may have been the one who brought up the issue in 1998. The=20quick-and-dirty solution I ended up with was to store two different=20versions of each relevant text block in the databases, one for diplay=20and another one with a simplified chracter set for searches. Then I=20added a note to the search forms telling visitors to use the simplified=20chracters. Not a good solution but at that time it was the best I could=20come up with. With Unicode it should be possible to use a better solution=.Frank Nordberghttp://www.musicaviva.comhttp://stores.ebay.com/Nordbergs-Music-Store?refid=3Dstore
Associated Messages, from the most recent to the oldest:
Dan Strong wrote:>
[url][/url]?That won't work since "e" and "=E9" will still be different=20chracters/chracter strings after
[url].There are two ways to solve this.The best solution is probably to treat all tricky characters as=20wildcards. Problem is, I'm not sure if it's possible to do wildcard=20searches with WebDNA.The other solution is to use a table of all the tricky characters and=20which ones they should be replaced with. This wasn't really an option=20back in '98 with all the different ascii extensions in use at that time.=20But today all modern computers use Unicode which make this solution much=20easier to apply.Of course, ideally this character conversion feature sould be built in=20to WebDNA. Definitely something to add to the wish list for the next=20upgrade. In the meantime it shouldn't be that difficult to script.I may have been the one who brought up the issue in 1998. The=20quick-and-dirty solution I ended up with was to store two different=20versions of each relevant text block in the databases, one for diplay=20and another one with a simplified chracter set for searches. Then I=20added a note to the search forms telling visitors to use the simplified=20chracters. Not a good solution but at that time it was the best I could=20come up with. With Unicode it should be possible to use a better solution=.Frank Nordberghttp://www.musicaviva.comhttp://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:
Setting up WebCatalog with Retail Pro data (1996)
[WebDNA] [OT] the "Work in progress" thread. (2009)
Truncated value after space - refresh my memory.... (1997)
Plugin or CGI or both (1997)
listfiles, moving files (1998)
hard carriage returns and sendmail (1998)
Nesting format tags (1997)
WebCat 3.04-3.07 plug-in dying on server.... (2000)
OT: Typhoon (1998)
Personal Web Server (1998)
Break out of a loop? (2000)
[OT] Deploying XRAID (2003)
Delete context run amok (2005)
Locking up with WebCatalog... (1997)
Install Webcatalog under NT4.0 and Microsoft IIS 2.0 (1997)
best way to store prefs (1998)
Rendering out a page (1997)
Credit card types (1997)
Click-through/Referral tracking solution needed (2000)
Database of Tax Rates? (1997)