 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
Java Forum / Databases / October 2003JDBC:how to compare char[] and int
the type of database column is char[2], how can i compare it to a int through JDBC? The database isn't support TO_NUMBER(column) >= i. Thanks a lot! > the type of database column is char[2], how can i compare it to a int > through JDBC? The database isn't support TO_NUMBER(column) >= i. > Thanks a lot! JDBC won't help you; it will have to be SQL. Perhaps your DBMS supports an equivalent construct, like CAST. Which DBMS is it?  SignatureLee Fesperman, FirstSQL, Inc. (http://www.firstsql.com) ============================================================== * The Ultimate DBMS is here! * FirstSQL/J Object/Relational DBMS (http://www.firstsql.com) Thank your answer. The DBMS is Himalaya. > > the type of database column is char[2], how can i compare it to a int > > through JDBC? The database isn't support TO_NUMBER(column) >= i. > > Thanks a lot! > > JDBC won't help you; it will have to be SQL. Perhaps your DBMS supports an equivalent > construct, like CAST. Which DBMS is it? > Thank your answer. > The DBMS is Himalaya. Sorry, I'd never heard of it. I'm afraid you'll have to scour through the docs. Look for CAST (the SQL92 construct) or perhaps CONVERT. SignatureLee Fesperman, FirstSQL, Inc. (http://www.firstsql.com) ============================================================== * The Ultimate DBMS is here! * FirstSQL/J Object/Relational DBMS (http://www.firstsql.com) thank you a lot. I will look at it. > > Thank your answer. > > The DBMS is Himalaya. > > Sorry, I'd never heard of it. I'm afraid you'll have to scour through the docs. > > Look for CAST (the SQL92 construct) or perhaps CONVERT. Free MagazinesGet 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 ...
|
Reply to this Message
|
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.