char - getString() ?

[kelvin cheung]

  char ka = rs.getString(4);

i try to get a char type from a table.
but i get : incopatible types
and i am sure that the colum is of the type char in the table.

whats wrong here?

[Purushoth Thambu]

You are trying to store "Object" type to "primitive" type. This will not work. Assign the getString() to another String object. That must solve your problem.

[Chris Staten]

Is this because the rs is an array and therefore the pointer in the array is of type object?

If so I think you can cast the object that you get from the array back into the actual type you want (in this case a char).

[Jeanne Boyarsky]

Kelvin,
Databases use char(x) and varchar(x) to represent strings. You need to use the getString() method as you are doing. If you happen to know your database field is only one character, you can use getString().charAt(0) to get the character.

Chris,
rs isn't really an array. It is an object of some type of list. (I'm not sure if that type is array, but I'm thinking it's not.) The resultset getXXX methods give you a more useful data type. For example, you could get a String, Date, int, ... You can get an int primitive back, but not a char primitive.

[Chris Staten]

Gotcha, thanks Jeanne