Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2005

    Unanswered: Case sensitivity

    When I perform the following sql query:

    select accountId as ACCOUNT_ID from account

    The column name comes out as "account_id".
    Is there a way to maintain the case of my column name?

  2. #2
    Join Date
    Mar 2004

    Normally Informix (and as far as I know all major databaes) are case insensitive in their SQL. Maybe this is an exception.
    In Informix you normally can change thsi behavior by setting the DELIMIDENT variable. In that case Informix will assume all qouted strings as case sensitive.

    In the past I looked at this, but decided not to use it. Nowaday's I'm sometimes using it when communication with other databases, when they expect IDS to be case sensitive.

    Hope this helps,


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts