SQL question

Thread view:

hoho123 - 05 Jul 2006 21:12 GMT

I have a column type char in a sybase database. what do I need to do in
the preparedStatement to set a string type to char?

Thanks in advance

Reply to this Message

Chris Smith - 05 Jul 2006 21:24 GMT

> I have a column type char in a sybase database. what do I need to do in
> the preparedStatement to set a string type to char?

PreparedStatement's setString is the correct method to call for the SQL
CHAR data type. Unless you're calling setNull, you don't need to
specify the type. If you are calling setNull, then you may specify the
type as java.sql.Types.CHAR.

Signature

Chris Smith - Lead Software Developer / Technical Trainer
MindIQ Corporation

Reply to this Message

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...