Skip to main content
Participant
February 11, 2009
Question

Oracle fixedString

  • February 11, 2009
  • 1 reply
  • 832 views
When I use thin JDBC driver to Oracle, the comparation of char columns with cfqueryparam must have the exact length, but if I use the fixedString connection property it would compare without the trailing blanks.
I try in the "Connection String" "fixedString=true" but it does not work
This topic has been closed for replies.

1 reply

Participant
February 11, 2009
I could set the connection property "fixedString" with the System property "oracle.jdbc.fixedString", but it did not work.
Does any one know how can I do a query with a comparation of a char column with cfqueryparam to Oracle, with Coldfusion 8 Standar Edition (Oracle JDBC driver)?