Unicode "Like" Text Search

From: Alex Maghen (AlexMaghen_at_discussions.microsoft.com)
Date: 12/29/04 

Date: Wed, 29 Dec 2004 12:39:06 -0800

Hi. I have an Access Database with several Unicode Text Columns. I need to
write a SQL query which will search these columns with a "...where column
like '%xxx%'" clause. But here's my problem: Many of these entries have
unicode characters in them that represent diacretical marks, etc. When the
user types in the search string, they certainly will not enter those marks.
Is there a way to search a column and specifically *excluse* certain
characters or ranges of characters so that the text matches even if those
characters aren't included in the search string?

Thanks for any help.

Alex

Relevant Pages

  • Re: Unicode Support
    ... >> (I know this is a poor example, but think about other languages, eg ... First things first, when you register your RosAsm windows classes, you ... the messages with ANSI / UNICODE parameters in ANSI or UNICODE form... ... with their alphabet characters, as with the numbers and punctuation...so, ...
    (alt.lang.asm)
  • Re: heeeeeeeeeeeeeeeellllllllllllllppppppppppppppppppppp
    ... This means that if you develop the bad habit of using char * (left over ... It usually takes me five minutes to create a Unicode version of any of my apps, ... BOOL and bool are different data types. ... can be up to MAX_PATH characters). ...
    (microsoft.public.vc.mfc)
  • Re: How to check variables for uniqueness ?
    ... characters is the sequence SS. ... is simply capitalizing strings. ... The fact that case mapping in English /is/ simple is neither here not ... That is a fair criticism of the Unicode position. ...
    (comp.lang.java.programmer)
  • Horribly overdue update to unicode.txt
    ... of the Linux Assigned Names And Numbers Authority project. ... The Linux kernel code has been rewritten to use Unicode to map ... In particular, ESC (U is no longer "straight to font", since the font ... Actual characters assigned in the Linux Zone ...
    (Linux-Kernel)
  • Re: Unicode Support
    ... > | single bit extra from ASCII for any ordinary ASCII characters... ... UNICODE character then check what "range" it's in with the table ... 7-bit ASCII characters are encoded in exactly the same way in UTF-8 ... All non-ASCII characters use a multi-byte sequence ...
    (alt.lang.asm)