I'm having some problems with character encoding in the grid.
I'm using json to load the data into the grid. The data contains some special characters (é for example).
When I directly display the result from my query the character is displayed correctly. After json_encoding it the result is:
As you can see it's now a \u0000.
When displaying the data in the grid firefox just ignores this character (displaying nam, it should have been namé) and ie stops rendering the data.
Adding a CONVERT(col USING ASCII) solves the problem but now ? tokens are displayed, not a very neat solution...