KNOWLEDGE BASE
Log In    |    Knowledge Base    |    4D Home
Tech Note: Case-Sensitive Operations in 4th Dimension
PRODUCT: 4D | VERSION: 2004 | PLATFORM: Mac & Win
Published On: December 13, 2005
Your current browser may not allow you to download the asset. We recommend Mozilla Firefox or Google Chrome.
Log In

The 4th Dimension language and database engine don’t automatically compare values case-sensitively. Instead, upper- and lower-case versions of a letter, and many of their diacritically marked variations, are considered equal. For example, the QUERY command treats the following characters as identical:
  e é E É Ë
It is often helpful that 4th Dimension doesn’t distinguish between case and diacritically distinct characters. This behavior is an obstacle, however, when you need to compare values case-sensitively.

Download Complete Tech Note and Example: Windows | Mac