Re: Like operator with accented character

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

On Sun, 22 Jan 2006 20:57:34 -0000, "John" <John@xxxxxxxxxxxxxxxxxxxx>
wrote:

>Hi
>
>I am using Like "*[!-!0-9A-Z &,.@/'():+]*" in my select query to exclude all
>characters listed but the query also excludes accented characters? Is there
>a way that accented characters are not included in this filter?

Yes. The ASCII value for accented characters is is different than the
non-accented characters: é is 233, e is 65.

I'm not certain how the LIKE operator handles upper vs. lower case (e
and E are different ASCII values as well), but try

Like "*[!-!0-9A-ZÀ-Ý &,.@/'():+]*"

You may want to use some VBA code to include the characters you want
to include, rather than excluding the thousands of possible Unicode
characters that might get typed by imaginative users. ?å?ï?fæç?ò?ÿ?

John W. Vinson[MVP]
.

Relevant Pages

  • Finding a Range of Unicode Characters
    ... 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? ...
    (comp.databases.filemaker)
  • 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
    ... E in the query. ... >>characters listed but the query also excludes accented characters? ... 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)