|
The following query fails because the database
column is defined as CHAR(10) and my matching parameter is only 3
characters:
"select i from " + HelpItem.class.getName() + " i
where i.type = $1"
query.bind("OFF");
In straight JDBC on Oracle I've used the trim()
function. What's the equivalent OQL syntax to match a value that is padded with
spaces in a CHAR column?
Thanks in advance.
Shannon Kendrick
|
