Kbase P117844: Does Progress DataServer for MS SQL Server support UTF-8 code page (Unicode)
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
2/8/2010 |
|
Status: Verified
GOAL:
Does Progress DataServer for MS SQL Server support UTF-8 code page (Unicode)
GOAL:
Does MS SQL Server DataServer support Unicode?
FACT(s) (Environment):
OpenEdge 10.1C
OpenEdge 10.2x
Windows NT 32 Intel/Windows 2000
FIX:
The DataServer for MS SQL Server supports the UTF-8 (Unicode) data types defined in the SQL Server versions 10.1C and above. Enabling Unicode support in the DataServer for MS SQL Server provides the following functionality:
? Completes the connection between UTF-8 support in the OpenEdge Advanced Business Language (ABL) client and UCS-2 support in MS SQL Server
? Allows Unicode data to be passed to and from MS SQL Server data sources
? Provides a migration path for Unicode character data type definitions in ABL to MS SQL Server, and vice versaIn order to use Unicode in the OpenEdge DataServer for MS SQL Server, you must use Microsoft SQL Server 2005 or later, and the DataDirect DirectConnect ODBC driver for MS SQL Server, Version 5.1 or later, or Microsoft MS SQL server driver or SQL native client driver.