Problem Note 43977: The database character set must be WE8ISO8859P1 or WE8MSWIN1252 in SAS® Merchandise Planning
In SAS® Merchandise Planning, the database character set must be WE8ISO8859P1 or WE8MSWIN1252. If you use NLS_CHARACTERSET AL32UTF8, worksheets do not open. Multi-language character sets are not supported. Using the UTF8 character set causes issues with the ODBC driver. If the database is already created with UTF8, you must recreate the database with WE8ISO8859P1 or WE8MSWIN1252 for SAS Merchandise Planning to work correctly.
The following paragraph includes errors seen when trying to open worksheets using a database with the NLS_CHARACTERSET AL32UTF8 character set. The errors are connected with fields that have a "VARCHAR2" type.
<LogMsg Type='Debug' Uptime='0'> SELECT * FROM MAXDATA.PLANVERSION WHERE
MAXDATA.PLANVERSION.PLANVERSION_ID = (SELECT PLANVERSION_ID FROM
MAXDATA.PLANWORKSHEET WHERE PLANWORKSHEET_ID = 1008) < LogDetails
File='ODBCRecordset.cpp' Line='1131' LocalTime='Thu Aug 11 09:00:46 2011'
SystemTime='1313067646' /> < /LogMsg>
< LogMsg Type='Warning' Uptime='0'> Unknown data type column NAME< LogDetails
Error='1020001' Facility='Database' File='ODBCRecordset.cpp' Line='1407'
LocalTime='Thu Aug 11 09:00:46 2011' SystemTime='1313067646' /> < /LogMsg>
< LogMsg Type='Warning' Uptime='0'> Unknown data type column
DESCRIPTION< LogDetails Error='1020001' Facility='Database'
File='ODBCRecordset.cpp' Line='1407' LocalTime='Thu Aug 11 09:00:46 2011'
SystemTime='1313067646' />< /LogMsg>
Operating System and Release Information
| SAS System | SAS Merchandise Financial Planning and SAS Merchandise In-Season Management | 64-bit Enabled AIX | 6.1.3M5 | | 9.1 TS1M3 SP4 | |
| Microsoft Windows 2000 Professional | 6.1.3M5 | | 9.1 TS1M3 SP4 | |
| 64-bit Enabled Solaris | 6.1.3M5 | | 9.1 TS1M3 SP4 | |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
If you use NLS_CHARACTERSET AL32UTF8, then the worksheets do not open.
| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2016-11-07 10:30:36 |
| Date Created: | 2011-08-11 16:08:05 |
