Kbase P86137: Is the unknown value fully consistent with the Progress behavior when SQL Server databases ANSI_NULL
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/14/2004 |
|
Status: Unverified
GOAL:
Is the unknown value fully consistent with the Progress behavior when SQL Server database's ANSI_NULLS is set to off?
GOAL:
Does the progress unknown value work the same way with SQL Server DataServer when SQL Server database's ANSI_NULLS is set to off?
FACT(s) (Environment):
MS SQL DataServer
FIX:
The Progress SQL Server DataServer and the ODBC DataServer products were designed on the basis of the foreign database's functionality with regards to SQL 92 compatibility, while trying to keep as much progress functionality as possible. Progress never tested setting the ANSI_NULLS off or any other parameters which may change the SQL 92 standard behaviors. By setting the ANSI_NULLS off, you may get the expected results you are looking for, but it might have differences in sorting or accessing data. The data also may get corrupted since the DataServer may not know for sure what the null character is and therefore may not recognize that the field contains a null.