corrupted special characters in csv file

[ChandraSaiKarthik]

Issue with improper character encoding handling during file generation or import. The system should correctly preserve all special characters (e.g., German, Scandinavian accents) using UTF‑8 or relevant encoding.
w3schools_dbo_Products.csv

Impact:
Incorrect product names displayed in downstream processes, leading to data quality issues and potential functional inconsistencies.

Expected:
All the values should retain their original special characters without corruption.

[jonaraphael]

Thanks so much for opening this issue and for the clear report.
I will reproduce this first, then implement the smallest safe fix, add/update tests, and share a PR for your review.

[jonaraphael]

Quick triage update: this is friendly and in scope, but fixing encoding issues safely requires the source encoding details.\n\nPlease share the original file encoding (for example UTF-8/Windows-1252/ISO-8859-1), plus exact open/save steps and whether was used. With that, I can reproduce and propose a targeted fix.

[jonaraphael]

Correction to my previous comment: please confirm whether the command 'CSV: Change File Encoding' was used during your test steps.

[ChandraSaiKarthik]

The file was unchanged.
Even you can find the products list in the below URL with query "select * from products;" and click "run sql" button.

https://www.w3schools.com/sql/trysql.asp?filename=trysql_select_all