Flexgrid column sort on Japanese character

Posted by: nguyen on 5 May 2022, 6:54 pm EST

  • Posted 5 May 2022, 6:54 pm EST

    I have worked on FlexGrid,
    when perform sort on a column in Japanese, sort ordered data not same with Sql query result in datatable.
    Is sort default suppored for japanese character?

    For example in fiddle bellow click on Country column.
    http://jsfiddle.net/kzgypbta/
    Thanks!
  • Replied 8 May 2022, 11:06 pm EST

    Hello,

    We could not detect any difference in the behavior of sorting in FlexGrid and using SQL order by command.

    We have used the following SQL query to sort the country name:


    -- create a table
    CREATE TABLE countries(
    id INTEGER PRIMARY KEY,
    name TEXT NOT NULL
    );
    -- insert some values
    INSERT INTO countries VALUES (3,'鹿児島県');
    INSERT INTO countries VALUES (1, '三重県');
    INSERT INTO countries VALUES (2,'京東府');

    -- fetch sorted values
    SELECT * FROM countries order by name ;


    Could you please provide us with the information on the sorting behavior which is returned at your end using SQL, so that we compare the results and reply accordingly?


    Regards
    Dushyant Sharma
  • Replied 9 May 2022, 11:19 am EST

    Dear Dushyant Sharma,
    Thanks for your answer, for your information i left the evident image below.

    By another way, i have resolved my own issue by disable client sort by custom sortComparer like:
    $scope.flexgridData = new wijmo.collections.CollectionView(responseData,{
    sortComparer : function alphanum(a, b) {
    return 0;
    }
    }
    );

  • Replied 9 May 2022, 10:57 pm EST

    Hello,

    We are glad to know that your issue is resolved. However, if you wish to disable sorting behavior in complete FlexGrid you can use the allowSorting property and set it to "None" or if you wish to prevent the same in any given column, you can set the alowSorting property in the given flexgrid column to false.

    For more information on the same, please refer to the below link
    https://www.grapecity.com/wijmo/api/classes/wijmo_grid.flexgrid.html#allowsorting
    https://www.grapecity.com/wijmo/api/classes/wijmo_grid.column.html#allowsorting


    Regards
    Dushyant Sharma
Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels