Microsoft KB Archive/183565

From BetaArchive Wiki
Knowledge Base


Underlyingvalue Property Incorrect for Certain Characters

Article ID: 183565

Article Last Modified on 3/10/2004



APPLIES TO

  • Microsoft OLE DB Provider for AS/400 and VSAM 1.0, when used with:
    • Microsoft SNA Server 4.0



This article was previously published under Q183565

SYMPTOMS

The ADO property Underlyingvalue is often incorrect, generally with 8-bit ASCII characters. For example, ASCII character #162, the "cents" symbol, appears as o with a forward-accent in the underlying value property.

CAUSE

The client codepage is set to 437 (ASCII) instead of 1252 (ANSI) and, therefore, does not handle special characters.

Additionally, the OLE DB Provider does not accept 4-digit code-page numbers. The OLE DB Provider does not support conversion to the system's default ANSI code page.

STATUS

Microsoft has confirmed this to be a problem in Microsoft OLE DB Provider for AS/400 and VSAM version 1.00, included with Microsoft SNA Server version 4.0.

This problem was corrected in the latest SNA Server version 4.0 U.S. Service Pack. For information on obtaining this Service Pack, query on the following word in the Microsoft Knowledge Base (without the spaces):

S E R V P A C K


Keywords: kbbug kbfix KB183565