Hi

I have a table with a column of type float.

When I try to insert the following statement

" INSERT INTO TEST (C3_FLOAT) VALUES ('This is a long text ' ) "

using JDBC program, I get the following exeption Message with
SQLState as HY000:

"[Microsoft][SQLServer JDBC Driver][SQLServer]Error
converting data type nvarchar to float."

I can understand why the exception is obtained.

I am using Microsoft JDBC Type 4 Driver(Beta Version).

Whereas when I try to insert for a column of int type, I get the
following:
[Microsoft][SQLServer JDBC Driver][SQLServer]Syntax error converting the
nvarchar value 'This is a Long Text' to a column of data type int.
Here the SQLState is 22018.

Can I know why the difference in exception messages?






Regards
Balak