I solve my problem with the Hex value. I want only an integer in 4 bytes (it's a Color). Thanks for your answer, I had tested this methode but I prefer this way. Why "unsigned" is not supported with H2 ?
Le mardi 22 mai 2012 21:04:09 UTC+2, Thomas Mueller a écrit : > > Hi, > > Why not use BIGINT? It's a java.lang.Long, as required by the JDBC > Spec (not BigInteger). See also > > http://h2database.com/html/datatypes.html#bigint_type > http://docs.oracle.com/javase/1.4.2/docs/guide/jdbc/getstart/mapping.html > > Regards, > Thomas > > > On Mon, May 21, 2012 at 4:37 PM, Patrice <[email protected]> > wrote: > > Hi, > > > > I need a column with an integer unsigned on 4 bytes but in H2 this is > > signed. So when I want to put the value 4278190080 (FF000000H) I have > this > > message : Numeric value out of range: "4278190080". > > How to put this value ? I prefer don't use BigInt. > > > > Thank you. > > > > -- > > You received this message because you are subscribed to the Google > Groups > > "H2 Database" group. > > To view this discussion on the web visit > > https://groups.google.com/d/msg/h2-database/-/X6-fQIHI_r4J. > > To post to this group, send email to [email protected]. > > To unsubscribe from this group, send email to > > [email protected]. > > For more options, visit this group at > > http://groups.google.com/group/h2-database?hl=en. > -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To view this discussion on the web visit https://groups.google.com/d/msg/h2-database/-/JOc4pTNv1yQJ. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
