Leading and trailing spaces
- Last Updated: January 17, 2024
- 1 minute read
- OpenEdge
- Version 12.8
- Documentation
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.