Hi,

I have the following property definition:



A string which has more than 16 characters always get truncated to 16 in my current setup (NH 0.5, Sybase).

In the latest NH version, is it also the expected behaviour or should there be an exception here ?

cheers

Thibaut

I don't remember seeing any truncating code in NHibernate, could it be Sybase truncating the string?

I thought I answered this one already. Sorry...

The string(16) has nothing do do with the actual persistance of data in NH. Rather it is used in generating the tables from the mapping files. If your Sybase colum is indeed varchar(16) then Sybase is truncating the string when you persist the data. It works this waty in MSSQL2000 as well. (similar db engines). I'll bet mySQL does this too.

-devon

The syntax of type="String(16)" is an nh specific thing. What it does is generate IDbParameters with a length of 16. With MSSQL the IDbParameter will truncate the value at 16 chars. If it is specified as type="String" and a string that was 17 chars long was put in there then the database would throw an exception when the sql was executed.

The type="String(xx)" is something I never should have added, but I did it in an early version when I was having problems getting IDbCommand.Prepare() to work. I would have no complaints with ripping it out. I didn't know people were using it because I never really documented it (of course - you could say all of NH is not really documented :roll: )

mike, thanks for correcting me.

my vote would be to remove that code, ut i am just one developer.

-devon

oh. please do not remove it. Keep it undocumented.