Dataviewer 
Author: Zeljko B.
Visited 913,
Followers 1,
Shared 0
Hi. Is it possible to change the sort option in DataViewer? It doesn't sort according to Croatian language. Database is MySQL and on the server side the sorting is correct.
Please reply. Thanks.
Posted on the
Hello. I sent a notification about your question to the company employees, expect an answer from them here in the comments.
As far as I know, at the moment there is no way to change sorting settings.
Author
Then the control is unusable for Croatia, BiH, Slovenia, Macedonia, Serbia...
There is a lot of free database viewers on the net. Try to see if one of them is better.
And maybe check your MySql installation to see if it is configured correct regards charset and sorting.
Author
John please read my initial question - "Database is MySQL and on the server side the sorting is correct."
Then try to use another viewer, or make a simple script to present data sorted in a html-table.
If the sorting is OK in this other viewer then the problem is most probably in the X5-viewer-object.
If the sorting is not OK in this other viewer then the problem is most probably in the settings for your database.
I did read that the settings on server side is Ok - but how did you check that?
If the problem IS in the X5-viewer, then you will anyway have to use another method to present your data. And the X5 viewer is not the most sophisticated database viewer.
And - if the X5-viewer is the problem, then you should have your credits for that object back. But you have to be sure that the problem is in the X5-viewer.
Another method could be to make a view-table in your database and then use this as source for the X5-viewer.
Author
If I go to my hosting and use phpMyAdmin, open(browse) my table, sorting works perfect.
If I use another developing tool, for example VS2019-DataGrid and load data from the same table into that grid, sorting works fine.
This X5-viewer, sorting doesn't work as expected. I am not expecting credits back, but I do expect some "work-arround" to get it work.
I am not familiar with the VS2019-DataGrid.
I suggested the viewer-alternative to have the data presented on the client side as the X5-viewer does - this is the only way to compare.
But maybe that is what the VS2019-DataGrid also does.
I suggested the view-table as a work-around.
Don't expect INCOMEDIA to change anything in the viewer object. You could wait a long time for that.
I will now step out of this thread hoping INCOMEDIA will give a useful answer to you.
Just one more thing before I completely step out:
In the viewer there is 2 kinds of sorting. The first sorting is when the data is delivered from the server to the client. Here it is the servers sorting that decides the order in which the data is "delivered".
In most viewers there is an option where you can sort columns(ascending/descending). This is a thing that happens entirely on the client side. It is essential which character set is used. If you are not using UTF-8 then strange things can happen.
In my country the use of æ,ø and å is a well-known problem in presentation and sorting if the utf-8 is not used.