JDBC:how to compare char[] and int

From: longskyhw (longskyhw_at_hotmail.com)
Date: 10/22/03

  • Next message: Lee Fesperman: "Re: JDBC:how to compare char[] and int" 
    Date: Wed, 22 Oct 2003 15:56:38 +0800

    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!

  • Next message: Lee Fesperman: "Re: JDBC:how to compare char[] and int"

    Relevant Pages

    • Re: Get back uniqueid?
      ... you'd need a mapping between database column and your column, ... I added another query to the table, ... and the signature had it returning an int. ...
      (microsoft.public.dotnet.framework.adonet)
    • Re: using string instead of int
      ... When your database column has an "int" type, you can easily do something like: ... but this will fail if there are "null"s in that column. ... Hans Kesting ...
      (microsoft.public.dotnet.framework.aspnet)
    • Re: using string instead of int
      ... IMO it's best to always work with the ... intended type (that is int if your database column is an int).... ...
      (microsoft.public.dotnet.framework.aspnet)