Hi, I m using a sybase database and type-4 driver.I have read that using prepared statement we don't need to use the escape character as prepareStatement put it internally but i do face a problem with single quote (')..though i m using prepared statement only. Can anyone help me in this.
It might be something the driver isn't doing correctly, but usually you don't have to worry about single quotes in PreparedStatements - they just get looked after. Did you want to post a small snippet of code to show your population of data?
Varun Khanna
Ranch Hand
Joined: May 30, 2002
Posts: 1400
posted
0
Thanks David I have got the point where i was making error. I just want to know can i set a "text" field by using setXXX() method of JDBC ( like setInt(),setLong() or setObject() ) ?we don't have any method like setText() or we have to use raw SQL string if we have datafield column as "text" in db ?? Thnx.