Skip to main content
O
obonilla66
Participant
February 11, 2009
Question

Oracle fixedString

  • February 11, 2009
  • 1 reply
  • 560 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

    O
    obonilla66Author
    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)?
    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices