phone number (text) drop starting 0 on datatable

Lapointe

Datatable display varchar number with leading 0 without this (these) 0

    var table = $('#donnees').DataTable( {
        dom: "PQBlfrtp",
            ajax: {
....
        columns: [ 
            {data: 'utilisateurs.Telephone'}
        ],....

show

when database data is

php is

            Editor::inst( $db, $TblName )
                ->fields(
                    Field::inst( 'utilisateurs.ID'),
                    Field::inst( 'utilisateurs.Telephone' )
                        ->validator( Validate::notEmpty( ValidateOptions::inst()
                            ->message( 'le numéro de téléphone doit être renseigné...' )
                        )
                    ),
                    Field::inst( 'utilisateurs.ID_Statut' ), ...

Any help please ?

Lapointe

at run time

mysql table utilisateurs

tangerine

Same issue reported here:
https://datatables.net/forums/discussion/65305/leading-zero-problem#latest

Lapointe

hi @tangerine @colin
Sorry... I vas trying to understand why and had not found the post about this point...
So the problem is the same...

Lapointe

old release works fine

Lapointe

please close.... Allan did solve problem