Hi,
seems that there are two different problems. One is with CSV export - currently management console uses current system encoding instead of UTF-8, which can produce files like you have shown. I just fixed that, next version will always use UTF-8 for CSV encoding.
Second issue is likely database encoding - as we are using varchar fields text is converted to whatever character set is choosen for database, with all unsupported Unicode characters converted to ?. Easiest option probably would be to switch database to UTF-8 encoding, but is is only available for SQL Server 2019. If you only encounter such characters in software inventory, you can try to change data type for columns in table software_inventory to NVARCHAR from VARCHAR. I have registered issue in our bugtracker for considering switching to NVARCHAR for MS SQL: https://track.radensolutions.com/issue/NX-2016 - if implemented it will solve issues like this one.
Best regards,
Victor
seems that there are two different problems. One is with CSV export - currently management console uses current system encoding instead of UTF-8, which can produce files like you have shown. I just fixed that, next version will always use UTF-8 for CSV encoding.
Second issue is likely database encoding - as we are using varchar fields text is converted to whatever character set is choosen for database, with all unsupported Unicode characters converted to ?. Easiest option probably would be to switch database to UTF-8 encoding, but is is only available for SQL Server 2019. If you only encounter such characters in software inventory, you can try to change data type for columns in table software_inventory to NVARCHAR from VARCHAR. I have registered issue in our bugtracker for considering switching to NVARCHAR for MS SQL: https://track.radensolutions.com/issue/NX-2016 - if implemented it will solve issues like this one.
Best regards,
Victor
