Hi Scott, While I look into this in 2.4.2, would you mind trying any of the daily-snapshots of trunk?
Thanks, V. Varadhan On Tue, 2009-07-28 at 14:50 -0700, srf wrote: > 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 > > > > > _______________________________________________ Mono-list maillist - [email protected] http://lists.ximian.com/mailman/listinfo/mono-list
