oh yes, I forgot to mention, it was mono 2.4.2 production release. Were those patches after this release. If you know that it was addressed in a commited patch I could get the latest daily and try it.
thanks scott Nagappan wrote: > > Hello Scott, > > Which version of Mono are you using ? I remember Varadhan have recently > committed lots of fix related to this area in ADO.NET. > > Thanks > Nagappan > > On Tue, Jul 28, 2009 at 2:18 PM, srf <[email protected]> wrote: > >> >> I cant give you the exact ado .net commands since we use an Nhibernate >> Orm >> but using its tracing , this is what its preparing: >> INSERT INTO dbo.[EntityLabel] ([commitcount], [Saved], [Username], >> [Comment], [IsSnapshot], [Name], [Created], [Description], Id) VALUES >> (@p0, >> @p1, @p2, @p3, @p4, @p5, @p6, @p7, @p8); @p0 = '1', @p1 = '', @p2 = >> 'Default', @p3 = '', @p4 = 'False', @p5 = '', @p6 = '7/28/2009 9:11:29 >> AM', >> @p7 = '', @p8 = '1c0a122a-1e26-4fc7-af5b-70c19f783188' >> >> Note the p1 ,p3 and p5 values are empty strings. WHen I trace its using >> the >> sqlserver profiler, the sql generated and being sent to the databaswe is >> actually null values. When I try this on windows everything is the same >> except that the empty strings remain as empty string. I noticed that >> everywhere when we insert empty strings they get inserted as nulls so it >> seems to be common to everything. Do you have any thoughts on why this >> would >> be happening. Is there some asumptions mono is taking to decide to set >> them >> to null? As far as I know the only way it should is if I use the >> System.Dbnull type >> >> thanks >> >> scott >> >> >> Nagappan wrote: >> > >> > Hello Scott, >> > >> > Can you post a sample test to reproduce the issue you have mentioned >> here >> > ? >> > >> > Thanks >> > Nagappan >> > >> > On Tue, Jul 28, 2009 at 1:41 PM, srf <[email protected]> wrote: >> > >> >> >> >> if I have a field that is an empty string rather than a null , when it >> >> gets >> >> saved it inserts a null rather than an empty string. With windows its >> >> works >> >> properly and stored an empty string. Has anyone else noticed this and >> had >> >> problems storing an empty string rather than a null value into a >> >> sqlserver >> >> 2005 database or any other database? >> >> >> >> thanks >> >> >> >> scott >> >> -- >> >> View this message in context: >> >> >> http://www.nabble.com/Empty-string-saved-as-null-in-sql-server-tp24707463p24707463.html >> >> Sent from the Mono - General mailing list archive at Nabble.com. >> >> >> >> _______________________________________________ >> >> Mono-list maillist - [email protected] >> >> http://lists.ximian.com/mailman/listinfo/mono-list >> >> >> > >> > >> > >> > -- >> > Linux Desktop (GUI Application) Testing Project - >> > http://ldtp.freedesktop.org >> > http://nagappanal.blogspot.com >> > >> > _______________________________________________ >> > Mono-list maillist - [email protected] >> > http://lists.ximian.com/mailman/listinfo/mono-list >> > >> > >> >> -- >> View this message in context: >> http://www.nabble.com/Empty-string-saved-as-null-in-sql-server-tp24707463p24708036.html >> Sent from the Mono - General mailing list archive at Nabble.com. >> >> _______________________________________________ >> Mono-list maillist - [email protected] >> http://lists.ximian.com/mailman/listinfo/mono-list >> > > > > -- > Linux Desktop (GUI Application) Testing Project - > http://ldtp.freedesktop.org > http://nagappanal.blogspot.com > > _______________________________________________ > Mono-list maillist - [email protected] > http://lists.ximian.com/mailman/listinfo/mono-list > > -- View this message in context: http://www.nabble.com/Empty-string-saved-as-null-in-sql-server-tp24707463p24708531.html Sent from the Mono - General mailing list archive at Nabble.com. _______________________________________________ Mono-list maillist - [email protected] http://lists.ximian.com/mailman/listinfo/mono-list
