Query Microsoft Text Driver (*.txt; *.csv) ODBCJT32 Specify charset

[Shreedhar]

Gurus,

I am using Microsoft Text Driver (*.txt; *.csv) ODBCJT32 to import CSV which has accented characters (ŠŽšžŸÀÁÂÃÄÅÇÈÉÊËÌ), currently the query result appears as ASCII characters and so the accented characters appears as JUNK chars(ÅŽšžŸÀÁÂÃÄÃ), but I want the accented characters to appear as it is in the CSV file.

Is is possible to specify charset (ANSI, UTF8) while querying CSV sheet.

Would be grateful for any insight to solve this issue.

Thanks for your time.

Best Regards, Shreedhar

 

[Hui]

Have a look at:
https://www.itg.ias.edu/content/how-import-csv-file-uses-utf-8-character-encoding-0

or

https://superuser.com/questions/911369/change-default-encoding-of-excel-to-utf-8

 

[Shreedhar]

Have a look at:
https://www.itg.ias.edu/content/how-import-csv-file-uses-utf-8-character-encoding-0

or

https://superuser.com/questions/911369/change-default-encoding-of-excel-to-utf-8

Thanks Hui, I am not using direct text import & the wizard. I was looking for options when querying CSV file using SQL ...ADODB /Microsoft Text Driver (*.txt; *.csv) ODBCJT32

 

[Chihiro]

Since text files do not have schema info within the file itself you will need to create schema.ini file in the same folder containing text file.
In there you specify CharacterSet to Unicode.

See links for more details.
http://teradataforum.com/teradata/20041029_083023.htm
https://chandoo.org/forum/threads/ado-connection-csv-issue-with-mixed-data-type.34097/

 

[Shreedhar]

Since text files do not have schema info within the file itself you will need to create schema.ini file in the same folder containing text file.
In there you specify CharacterSet to Unicode.

See links for more details.
http://teradataforum.com/teradata/20041029_083023.htm
https://chandoo.org/forum/threads/ado-connection-csv-issue-with-mixed-data-type.34097/

Thanks Chihiro...
Works well if the source file has the same encoding but, my current scenario data file comes some times with ANSI, UTF8, UTF-8-BOM.

Please share suggestions to handle this scenario efficiently...

Thanks for your help & suggestions

 

[Shreedhar]

Since text files do not have schema info within the file itself you will need to create schema.ini file in the same folder containing text file.
In there you specify CharacterSet to Unicode.

See links for more details.
http://teradataforum.com/teradata/20041029_083023.htm
https://chandoo.org/forum/threads/ado-connection-csv-issue-with-mixed-data-type.34097/

Chihiro,

I used Microsoft.Jet.OLEDB.4.0 driver as an alternate to solve the issue. This driver has extended properties that supports CharacterSet parameter.

Thanks for your help