PxPlus User Forum

Twitter Twitter Twitter

Author Topic: ODBC driver that supports files with UTF-8 data  (Read 1390 times)

Tino

  • Member
  • **
  • Posts: 6
    • View Profile
ODBC driver that supports files with UTF-8 data
« on: September 06, 2018, 11:09:36 AM »
As the current ODBC driver only supports ANSI data, it's not possible yet to get files correctly with UTF-8 data fields. 

If other people need this too, please 'like' this topic.

Regards,
Tino

Mike King

  • Diamond Member
  • *****
  • Posts: 3810
  • Mike King
    • View Profile
    • BBSysco Consulting
Re: ODBC driver that supports files with UTF-8 data
« Reply #1 on: September 06, 2018, 02:52:12 PM »
The current ODBC driver returns whatever data you put in the database.  It is up to the application to know which character set the data is in.

For example if you use our current SQL ODBC driver from something like Open Office, you can simply tell the system that the data source uses UTF-8 for its data and everything is handled automatically.  This is no different than if your files contained data using other character sets such as Thai, Greek, or Cyrillic.

Unfortunately the most common program people use for ODBC access, Microsoft Excel, does not appear to offer a Character Set option when importing data from an ODBC data source so you need to use some other utility.  Excel itself does support opening/importing files with different character sets and provides character set 65001 as an option, however the MS Query tool does not appear to provide any character set selection functionality.
Mike King
President - BBSysco Consulting
eMail: mike.king@bbsysco.com