Didn't mean it in that way, sorry doesn't make any sense :-) I usually use
"ASCII" (US-ASCII) in my vocabulary as English characters, but 0xC0, 0xC1,
etc... is a good example of where I should loose that habbit.
What I ment was for example you can convert 0xC0-0xC5 to 0x41 which will
convert all chars similar to A to A, etc..., then the data retrieved from db
can also be compared likely, which perl is very good at, or another option
would be to store accent insensitive in db, by storing all 0xC0-0xC5 as
0x41. There are many options, not sure which ones are more efficient than
others. Any ways converting to single searchable format is one option.
Another would be to store all possibilities in a hash
%char{'A'}->[0..10] = qw(hex1, hex2, etc...);
and then use the hash in the in() clause.
Ilya Sterin
-----Original Message-----
From: Kokarski, Anton
To: Sterin, Ilya; 'Tim Bunce '; '[EMAIL PROTECTED] '
Cc: '[EMAIL PROTECTED] '
Sent: 06/01/2001 2:54 PM
Subject: RE: (Fwd) Accent insensitive
Sorry that I have missed the resolution, but just out of curiosity.
How do you convert it to ASCII.
Anton
-----Original Message-----
From: Sterin, Ilya [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 01, 2001 1:51 PM
To: 'Tim Bunce '; '[EMAIL PROTECTED] '
Cc: '[EMAIL PROTECTED] '
Subject: RE: (Fwd) Accent insensitive
You've already asked that question here before and got lots of replies,
did
that not suit your needs? Tim, like the rest of people, prefers that
you
not send any DBI/DBD related questions directly to him, but rather to
the
dbi-users list which he subscribes to also and I'm preatty sure he saw
your
question before. Anyways, I thought that it was resolved? If not there
were many solutions that were specified, one being you converting all
the
possible characters to ASCII as it is stored by you in the database and
then
searching based on that, you can also keep a copy of the pre-converted
string to later display to the user.
Ilya Sterin
-----Original Message-----
From: Tim Bunce
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: 06/01/2001 2:44 PM
Subject: (Fwd) Accent insensitive
----- Forwarded message from webmaster <[EMAIL PROTECTED]> -----
From: webmaster <[EMAIL PROTECTED]>
To: "Tim.Bunce" <[EMAIL PROTECTED]>
Subject: Accent insensitive
Date: Fri, 1 Jun 2001 14:30:06 -0300
Hi, Tim. I need your help. But, first off all, dont mind about my
english.
Tim, i am using DBI accessing a ms access file ".mdb" with accented
marks word like josé.
When i make a search like "SELECT name FROM file WHERE name = 'josé' i
receive only the accented "josé" but not "jose" without accent.
Is there any feature that allows me search for a word in
accent-insensitive mode considering i am using a ".mdb file ?
Thank you very much and congratulations. Here in Brazil, you are very
famous.
Vivian Verwey Rousseau De La Fontaigne.
----- End forwarded message -----
