I would like to see how a MySQL table with my own data functions in the wpDataTables sandbox. My particular concern is about Indian language fields (utf8) it contains. I see some problems with such data when generating tables from csv data with your free (lite) plugi. I want to make sure that such problems do not arise when the data are sourced from MySQL directly through query.
You have option to import your CSV into database through our plugin and test it that way. You can find more information about it in our - Documentation.
We are setting CHARACTER SET=utf8 COLLATE utf8_general_ci upon creating tables in MySQL so it should work properly.
One more thing which I should mentioned here is that our support managers will gladly help you with any problem that you have with our plugin and that includes problems with character set.
Thanks for the response. I would really like to see the results from my MySQL database. I am attaching a very small table (11 col x 7 rows) with a sample of my actual data. Can you please add this to any of your databases and post the output table somewhere? I will break up the data into two tables eventually, but right now output of the entire table will do.
I will go for the purchase if the display comes out fine.
It is not easy for me to set up table where you can actually test it but I tested it in my local environment and record the output. As I can see it works normally. My only suggestion would be to use non special characters for column names in MySQL which will assure that all the functionalities working normally. Please take a look at the attachemnt to see it in action
Hello,
I would like to see how a MySQL table with my own data functions in the wpDataTables sandbox. My particular concern is about Indian language fields (utf8) it contains. I see some problems with such data when generating tables from csv data with your free (lite) plugi. I want to make sure that such problems do not arise when the data are sourced from MySQL directly through query.
Thanks.
Hi N M Pattnaik,
Thank you for your inquire.
You have option to import your CSV into database through our plugin and test it that way. You can find more information about it in our - Documentation.
We are setting CHARACTER SET=utf8 COLLATE utf8_general_ci upon creating tables in MySQL so it should work properly.
One more thing which I should mentioned here is that our support managers will gladly help you with any problem that you have with our plugin and that includes problems with character set.
Hello Miljko Milosevic,
Thanks for the response. I would really like to see the results from my MySQL database. I am attaching a very small table (11 col x 7 rows) with a sample of my actual data. Can you please add this to any of your databases and post the output table somewhere? I will break up the data into two tables eventually, but right now output of the entire table will do.
I will go for the purchase if the display comes out fine.
Hope this can be done soon.
Thanks.
Nikhil
Hi Nikhil,
It is not easy for me to set up table where you can actually test it but I tested it in my local environment and record the output. As I can see it works normally. My only suggestion would be to use non special characters for column names in MySQL which will assure that all the functionalities working normally. Please take a look at the attachemnt to see it in action