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)
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
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.