Problem with data not shown when I do a search (with Spanish words and names)

Problem with data not shown when I do a search (with Spanish words and names)

memememe Posts: 6Questions: 0Answers: 0
edited February 2012 in General
Hi everybody.

Some days ago, I used the server-side code, "Marios" show me to make spanish text searchs (using mysql + php 5) in datatables, that follows:

/*
* Filtering
* NOTE this does not match the built-in DataTables filtering which does it
* word by word on any field. It's possible to do here, but concerned about efficiency
* on very large tables, and MySQL's regex functionality is very limited
*/
$sWhere = "";
if ( $_GET['sSearch'] != "" )
{
$sWhere = "WHERE (";
for ( $i=0 ; $i (This part OK)


id Name Phone
1(_____) 607897654 <- Here should show "María", but it doesn't.
2 Mario 600123456
3 Miguel 601345678

Should I use a particular charset in html code, different collate in mysql tables, etc... ?

How could I solve it ?

Thanks in advance for your help
This discussion has been closed.