Skip to Content
Former Member
Jan 04, 2016 at 06:22 PM

SNC MSS2012 - Unicode - Internationalizing


Welcome 2016 & Hello All!

This is a wide open question:

A PB 12.5 application currently accesses SQLSVR 2012 using OLEDB with ANSI encoding. Goal is to internationalize the application with a Unicode UTF-8 or UTF-16 encoding accessed from PB 12.6 and SNC

What needs to be done to the DB and PB to support internationalization (storing / retrieving and editing in native languages)?

Documentation is sketchy at best The section titled "Unicode support in PB" says

"A Unicode database is a database whose character set is set to a Unicode format, such as UTF-8 or UTF-16. All data in the database is in Unicode format, and any data in the database must be converted to Unicode implicitly or explicitly"

The goal is that Varchar and Char type be accessed as Unicode with no datawindow or embedded sql changes. We do not want to have to converte all strings to NvarChar or NChar types

There is no doc for the SNC 12.6 driver.

How do we go about this?