Try OpenEdge Now
skip to main content
DataServer for Oracle
Initial Programming Considerations : Database design issues : Indexes : Leading and trailing spaces
 
Leading and trailing spaces
ABL and Oracle handle leading or trailing blanks in an indexed column differently. For example, when you attempt to create a record in Oracle and include leading or trailing blanks in a column that participates in a unique index, Oracle returns a message that there is a duplicate unique key. To address this, the DataServer, by default, trims leading or trailing blanks when you use them in a WHERE clause. If you want to specify leading or trailing blanks, specify the -znotrim startup parameter when you start the OpenEdge client session.