Type of Change: Enhancement
Product: Acu4GL
Module: MSSQL
New Version: 10.1.0
Machines Affected: Windows only
DESCRIPTION:
This ECN extends ECN-4363, in which Acu4GL for SQL Server can now read and write Unicode data from ANSI data in a COBOL program. It uses the COBOL_CHARACTER_SET configuration variable (as described in ECN-4363) to determine how to interpret the data, and then writes that data to the database. The columns being read and written must be of type nchar or nvarchar (not char or varchar).
This ECN introduces a new configuration variable, A_MSSQL_CREATE_UNICODE_COLUMNS. If set to TRUE, then the interface will create nchar or nvarchar columns for all text data. Note that existing tables are not affected. The default value for this variable is FALSE, meaning that default behavior is the same as in prior versions.
Visit the following web page for a list of supported code pages for MSSQL: https://technet.microsoft.com/en-us/library/ms186356(v=sql.105).aspx
From extend 10.1.0 onwards, The Acu4GLFD utility is able to produce an appropriate FD for an existing SQL server table that has columns defined as nchar or nvarchar.