Localization of data
-
My application pulls data from a MySQL database and saves it as CSV file. I have to localize this. the main requirement is that date and number format should be localized while making the CSV file. for ex in German, the delimiter should be ";" instead of " ," . and numbers should have , in place of decimal(1.23 should be 1, 23) and also the date should be in correct format. now the data I am pulling could be of any type, string, single, double, how can I know the type of pulled data, and format it for the installed UI culture before saving it to the CSV file. I know that I can find out the type of the column pulled, and use that, is there a better an efficient way ? Any ideas ? Thanks, Arti
-
My application pulls data from a MySQL database and saves it as CSV file. I have to localize this. the main requirement is that date and number format should be localized while making the CSV file. for ex in German, the delimiter should be ";" instead of " ," . and numbers should have , in place of decimal(1.23 should be 1, 23) and also the date should be in correct format. now the data I am pulling could be of any type, string, single, double, how can I know the type of pulled data, and format it for the installed UI culture before saving it to the CSV file. I know that I can find out the type of the column pulled, and use that, is there a better an efficient way ? Any ideas ? Thanks, Arti