Kbase 20001: Error 6227 occurs because unicode data-type is not supported by Progress
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
11/8/2010 |
|
Status: Verified
SYMPTOM(s):
Error 6227 occurs while running a query against SQL Server database
Error 6227 occurs while trying to pull table definitions from SQL Server
SYSTEM ERROR: Unicode unsupported. Bad datatype <datatype>. (6227)
SYSTEM ERROR: <proc-name>: Bad datatype <datatype>. (6227)
SYSTEM ERROR: _type_sqlc: Bad datatype <-8> (6227)
SYSTEM ERROR: _type_sqlc: Bad datatype <-9> (6227)
SYSTEM ERROR: _type_sqlc: Bad datatype <-10> (6227)
SYSTEM ERROR: _type_sqlc: Bad datatype <-11> (6227)
FACT(s) (Environment):
Progress 9.1x
MS SQL DataServer
ODBC DataServer
MS SQL
CAUSE:
Error 6227 occurs when a data type was not recognized by Progress. The DataServer ODBC / MS SQL Server does not support the Unicode (UTF-8) data types (column that has the 'N' type data type (nchar, nvarchar, ntext / nlongvarchar) or uniqueidentifier.
These data types are returned from the ODBC driver as -8, -9, -10 and
-11 datatypes respectively, which is reflect in the 6227 error message.
FIX:
These data-types can not be used until they are supported by Progress.