Van,
I know that I can write a function to handle this, but the main problem is
that I would need to do more than one search on the database. I can't
predict if the info on the database is with accent or without accent. So I'd
need ot write a function that calculates all the accent possibilities on the
word I passed as an argument, and the do as many queries as needed. This
would be time, cpu, everything consuming!
I would like a feature like MS-SQL Server has. You can set the order and
matching dictionaries. Someone told me that MySQL should has this feature.
Any tip about it?
Thanks,
Giancarlo
-----Original Message-----
From: Van [mailto:vanboers@stripped]
Sent: Monday, April 26, 1999 7:44 PM
To: Giancarlo Bonansea
Cc: 'mysql@stripped'
Subject: Re: Using special characters in foreign languages
Giancarlo Bonansea wrote:
>
> Hello all,
>
> I've been using MySQL 3.22.21 in the last 2 weeks and I'm writing from
> Brazil. Our language is Portuguese and we use some letters with accents,
> like a,á,c,ç and others.
>
> MySQL can handle them very well, I don't have problems doing INSERTs and
> SELECTs, but... I'd like to do a "SELECT * FROM <table> WHERE <field>
> LIKE
> '%e%'" and get as the result all the rows that contains fields with "e"
and
> "é". Forgetting accents is a very common mistake in Portuguese, so it's
> difficult to implement a search if we can't pass over this language
problem.
> What I'm trying to explain is that "Bagé" should be compared the same as
> "Bage".
>
> Is there a special configuration or compilation to activate this feature ?
>
> Thanks in advance,
>
> Giancarlo
> gbonanse@stripped
> gbonanse@stripped
Giancarlo,
You might need to write a custom function. Or, perhaps a module, but,
if you're not programming with MySQL, and, merely interfacing with a
web-interface like PHP, putting such a function together would be fairly
simple work. Try www.php.net.
Van
--
=========================================================================
Linux rocks!!! www.dedserius.com
=========================================================================
---------------------------------------------------------------------
Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
posting. To request this thread, e-mail mysql-thread2423@stripped
To unsubscribe, send a message to the address shown in the
List-Unsubscribe header of this message. If you cannot see it,
e-mail mysql-unsubscribe@stripped instead.
