Accent problem
Steel
In a mysql table I have many words (in several languages) with accent (like
fi�, st�va )
If I try to find a word that it contains an accent mysql not found it.
I am sure that into php query the word is exact For es:
SELECT *FROM words WHERE w=' fi�'
We had the same problem in phase of reading of the accented words whose
accents came transformed in a strange interrogative point and we solved this
problem with htmlentities ()
Please how can I do because query search found accented words?
ThanksAccent problem
Jerry Stuckle
This isn't a PHP question. You need to be asking in a MySQL newsgroup -
such as comp.databases.mysql.
--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstu...@attglobal.net
==================
Richard
"Steel" <st...@nonspam.com> wrote in message
news:a%y6n.15130$Ua....@twister2.libero.it...
If you put the data in the db with htmlentities, then you should also
use that in the query.
R.
Michael Fesser
Of course the better way would be to fix the encoding problem and change
the columns to UTF-8 where necessary.
Micha
Richard
"Michael Fesser" <net...@gmx.de> wrote in message
news:g9lml5t1gk1acq3el...@mfesser.de...
Probably, yes. This is the quick (and maybe dirty) way.
Depending on the situation, this may or may not be the best solution.
R.
"Álvaro G. Vicario"
Do your table and PHP script use the same character set? Do the column
values have leading spaces?
--
-- http://alvaro.es - �lvaro G. Vicario - Burgos, Spain
-- Mi sitio sobre programaci�n web: http://borrame.com
-- Mi web de humor satinado: http://www.demogracia.com
--