Prepared Statement and CHAR DB Field

Thread view:

A r F a N - 27 Mar 2006 07:33 GMT

All,

I have a field in Database which is of CHAR(6) type. I am using
prepared statement to set parameter value in this field. I used
setString method of prepared statement for this purpose but i didnt get
any success in it. When I use ' " + parameterName + "' it gives the
desired result but its not in case with setString.

Can any1 help me which prepared statement method should I use to set
parameter in this field.

Waiting for your replies

Regards.

Reply to this Message

Joe Weinstein - 27 Mar 2006 16:38 GMT

> All,
>
[quoted text clipped - 10 lines]
>
> Regards.

Either change the column to a varchar(6) or pad any parameter value
with blanks so it is always 6 characters long.
Joe Weinstein at BEA Systems

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 ...