Finding a Range of Unicode Characters

From: Cecil Bankston <cbankston@xxxxxxxxxxxxxxx>
Date: Mon, 28 Nov 2005 22:19:51 -0600

When I imported data into FM from another database program, some of the accented characters were changed into other ASCII or Unicode symbols. Is there any way I can do a find in a field to locate all records with any characters or symbols above the ASCII or Unicode range of standard English letters and punctuation marks without having to do separate finds for each individual symbol? -- Cecil N. Bankston Baton Rouge, LA USA .

Follow-Ups:
- Re: Finding a Range of Unicode Characters
  - From: Bill Marriott

Prev by Date: Re: Seeking elegant solutions in fm8 to this common problem
Next by Date: boxes in checkbox set sometimes do not show up
Previous by thread: Seeking elegant solutions in fm8 to this common problem
Next by thread: Re: Finding a Range of Unicode Characters
Index(es):
- Date
- Thread

Relevant Pages

Re: How ">=" Work on Varchar field?
... this has absolutely nothing to do with ASCII. ... or database, same goes for accented characters or other symbols outside the ... > find all rows with> value then the sum and display, ...
(microsoft.public.sqlserver.programming)
Unicode: matching a
... I'm working with Unicode strings to handle accented characters but I'm ... the latter doesn't match accented characters. ... obvisouly all be converted to ascii. ...
(comp.lang.python)
Re: Like operator with accented character
... >characters listed but the query also excludes accented characters? ... >a way that accented characters are not included in this filter? ... The ASCII value for accented characters is is different than the ...
(microsoft.public.access.queries)
Re: Like operator with accented character
... The accented characters are being included in this filter without being ... >>characters listed but the query also excludes accented characters? ... The ASCII value for accented characters is is different than the ...
(microsoft.public.access.queries)