Hello everyone!

I’m having trouble with language support. My application needs to work across our branches, and therefore, I have data in 10 languages: English, German, French, Italian, Spanish, Portuguese, Polish, Turkish, Chinese, and Russian.
When switching languages, the application updates the SQL query from the SQL Server and populates the grid using your ajax example.

I’m facing issues with:
1. French and Portuguese: When selecting these languages, an empty message with the title “Error” appears, and the grid remains empty.
2. Chinese and Russian: Characters in these languages (Chinese characters and Cyrillic) are displayed as question marks “?” in the grid, even though they appear correctly on the server.

Including localization JS files didn’t help, of course.

P.S. The server is set to “charset=UTF-8”. The SQL queries account for cases where data contains apostrophes.

Thanks!