[solved]The conversion of the nvarchar value overflowed an int column.
-
This is the error
com.microsoft.sqlserver.jdbc.SQLServerException: The conversion of the nvarchar value '8737383838' overflowed an int column.
I'm putting the value integer into bank account number column.
statement.setString(10,acnotxtfield.getText());
Using prepared Statement.
-
This is the error
com.microsoft.sqlserver.jdbc.SQLServerException: The conversion of the nvarchar value '8737383838' overflowed an int column.
I'm putting the value integer into bank account number column.
statement.setString(10,acnotxtfield.getText());
Using prepared Statement.
the value that you are trying to convert is larger than the
intcan handle. I would suggest that you change the type to Big Int int, bigint, smallint, and tinyint (Transact-SQL)[^]Every day, thousands of innocent plants are killed by vegetarians. Help end the violence EAT BACON
-
the value that you are trying to convert is larger than the
intcan handle. I would suggest that you change the type to Big Int int, bigint, smallint, and tinyint (Transact-SQL)[^]Every day, thousands of innocent plants are killed by vegetarians. Help end the violence EAT BACON
-
This is the error
com.microsoft.sqlserver.jdbc.SQLServerException: The conversion of the nvarchar value '8737383838' overflowed an int column.
I'm putting the value integer into bank account number column.
statement.setString(10,acnotxtfield.getText());
Using prepared Statement.
chdboy wrote:
bank account number
No, a
bank account number IS NOT a number. A number is something you do maths with. But what's the meaning of the sum of two bank account numbers? Consequently, use a textual respresentation, e.g. char(10). -
chdboy wrote:
bank account number
No, a
bank account number IS NOT a number. A number is something you do maths with. But what's the meaning of the sum of two bank account numbers? Consequently, use a textual respresentation, e.g. char(10). -
chdboy wrote:
bank account number
No, a
bank account number IS NOT a number. A number is something you do maths with. But what's the meaning of the sum of two bank account numbers? Consequently, use a textual respresentation, e.g. char(10).Exactly! Bank account numbers can start with a zero or even contain non-numeric characters.
“That which can be asserted without evidence, can be dismissed without evidence.”
― Christopher Hitchens
-
Exactly! Bank account numbers can start with a zero or even contain non-numeric characters.
“That which can be asserted without evidence, can be dismissed without evidence.”
― Christopher Hitchens
-
But they're still not numbers. As Bernhard said, you can't add two bank account numbers together.
"These people looked deep within my soul and assigned me a number based on the order in which I joined." - Homer
