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

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