Arabic numbers Search

abdallah101

Hi, I have problem with Arabic numbers search, I searched console and figured out that in search criteria value of search is empty and so there is no error just nothing happened.
I have customers who search with Arabic numbers is there any solution or configs Should be applied?

allan

Can you give me a link to a test case showing the issue please? There should be no problem using non-ASCII characters in SearchBuilder (which it looks like you are using).

Allan

abdallah101

Thanks Allan for reply
Here is a link with the case above

https://rabbitsmanager.com/app/allan/females

allan

Hi,

Thanks for the demo! The number ۱ can be seen in all rows of the table e.g.:

So none of them would be filtered out with that search. Also, it looks like you are using server-side processing, so the filtering is actually done by whatever server-side script you are using (fetch.php). Are you using your own code for that, or a library?

Allan

abdallah101

the search is the search builder it only search the exact column they are hidden
{ data: "id", visible: false },
{ data: "female_number", visible: false},
{ data: "female_type", visible: false },
{ data: "line" ,visible: false},
{ data: "home", visible: false },

and the visible row is
'data': null,visible: true,
'render': function (data) {codes} and none searchable
search builder config
depthLimit: 1,
columns: [1,2,3,4],

and fetch.php is editor library

<?php

/*
* Example PHP implementation used for the index.html example
*/

// DataTables PHP library
include( "../assets/editor/lib/DataTables.php" );

// Alias Editor classes so they are easy to use
use
DataTables\Editor,
DataTables\Editor\Field,
DataTables\Editor\Format,
DataTables\Editor\Mjoin,
DataTables\Editor\Options,
DataTables\Editor\Upload,
DataTables\Editor\Validate,
DataTables\Editor\ValidateOptions;

// Build our Editor instance and process the data coming from _POST
Editor::inst( $db, 'all_in_one' )
->fields(

    Field::inst( 'id' ),
    Field::inst( 'dating_method' ),
    Field::inst( 'female_id' ),
    Field::inst( 'female_number' ),
    Field::inst( 'female_type' ),
    Field::inst( 'line' ),
    Field::inst( 'home' ),
    Field::inst( 'male_id' ),
    Field::inst( 'male_number' ),
    Field::inst( 'male_type' ),
    Field::inst( 'male_line' ),
    Field::inst( 'male_home' ),
    Field::inst( 'nest' ),
    Field::inst( 'guess_result' ),
    Field::inst( 'birth_result' ),
    Field::inst( 'dating_date' ),
    Field::inst( 'birth_date' ),
    Field::inst( 'weaning_date' ),
    Field::inst( 'dating_time' ),

)
->where( function ( $q ) {
    $user_id=87;
    $q
        ->where( 'user_id',  $user_id, '=' );

} )
->debug(true)
->process( $_POST )
->json();

abdallah101

I noticed the same when trying do the same with examples on https://datatables.net/

abdallah101

and this from fetch.php payload
with English number

with Arabic number