Hi,
We are importing CSV file data into OutSystems using BulkInsert component.
We have few special characters(diacritics) in CSV data. Ex. ß, Ä , ä, ë, ï, ö, ü
When we do bulk insert data in OutSystems entity it's showing � in place of diacritics .
How to import this diacritics in database?
Best Regards,
Nitin
Hi Nitin,
This is probably due to the used database collation. Depending on the used code pages, you end up with these representations that don't match your expectations. I believe having a UTF-8 collation would not cause these issues.
My suggestion is to contact OutSystems by opening a support case, and let them understand you what database collation is used in your case, and if that is the root cause to your problem.
Some more information about database collation in OutSystems can be found here, but is only applicable for on-premise installations.
https://success.outsystems.com/support/enterprise_customers/maintenance_and_operations/change_the_collation_of_an_outsystems_database_running_on_sql_server/
Regards,
Daniel
Thanks @Daniel Kuhlmann !
I will update once issue is resolved.
Hi @Daniel Kuhlmann ,
Good Morning!
Thank you for your correct direction.
We have used CSVUtil Forge component for reading the CSV file.
This component provides option to configure the Encode. Default encode value is UTF-8.
You are correct, we have few CSV files in ANSI format and those got this issue for Umlaut characters.
We have solved this issue by converting CSV files to UTF-8.
https://www.outsystems.com/forums/discussion/52540/csvutil-special-characters-from-csv-file-such-as-n/