How to get the char data type from mysql using resultset

java api jdbc resultset
Kanishka Gupta picture Kanishka Gupta · Jun 7, 2013 · Viewed 30k times · Source

I have been doing CRUD operation on database, but i could not find any direct method for the getting the data type char in database.

Though i achieved the output using the getString(String column_name) of the result set, but i wonder why there does not exist any method like getChar(String column_name), since String and Character are two different data types.

Answer

ddmps picture ddmps · Jun 7, 2013

As MySQL sees it, it's all Strings because it has no type for a single character. Sure, you can set CHAR or VARCHAR to sizes of max one, but this is a special case and you generally don't want to make methods for special cases when the functionality is already there.

Just extract the Java char from the resulting String, as such:

getString(column_name).charAt(0)

Related questions

WhatsApp API (java/python)

I am looking for WhatsApp API, preferably a Python or Java library. I've tried Yowsup, but could not get my number registered; I am based in India and I am not sure if that has got anything to do with …

Read More
JPA Criteria API - How to add JOIN clause (as general sentence as possible)

I am trying to construct queries dynamically, and my next target is add JOIN clauses (I don't know how can I use the API). By now, for example, this code work for me : ... Class baseClass; ... CriteriaBuilder cb = JpaHandle.get().getCriteriaBuilder(); …

Read More
Android REST client, Sample?

Even if this thread has accepted answer, feel free to propose other ideas, you do use or like I've met these articles: Restful API service Java REST client API for Android And that lead me to this Google I/O 2010 …

Read More