Hello,

I am using Hibernate 3 + Annotions with JSE 6U10 against MSSQL Server 2000.

I have a very simple schema, like:

Market nvarchar(64) not null,
Price real not null,

and a POJO that corresponds: for nvarchar I use String, and for price double.

When analyzing the sql server logs, we have found that every single column has a CONVERT_IMPLICIT in the Prepared Statement.
Even though I have a nvarchar of length 64, the PS shows (@P0 nvarchar(4000)), the doubles also, even the ints have them.

Is there a way to configure my POJO via an annotation, or Hibernate itself so that no CONVERT_IMPLICIT happens on the server side?
Is there any performance impact of the use of CONVERT_IMPLICIT by the server?

Thank you