SAP Knowledge Base Article - Preview

3436551 - Use of case insensitive names - SAP ASE

Symptom

  • Can ASE have case insensitive identifiers, like table and column names ?
  • How to handle application queries which use a mix of cases in queries for identifier names ?

    For example

    create table test_Case (Hostname char(20))
    go

    select HostName from test_Case
    go
    Msg 207, Level 16, State 4:
    Invalid column name 'HostName'.

    select Hostname from test_case
    go

    Msg 208, Level 16, State 1:
    test_case not found....


Read more...

Environment

SAP Adaptive Server Enterprise (ASE)

Product

SAP Adaptive Server Enterprise all versions

Keywords

Case Sensitivity, Identifiers , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.