ok thanks, I filed Bug #526794 for this issue anyhow. Do you know how I can get the most recent source since the mono.ximian.com/daily isnt getting updated anymore? thanks
scott Veerapuram Varadhan wrote: > > On Wed, 2009-07-29 at 06:56 -0700, srf wrote: >> do you know where I can get the daily , on the daily page last daily > is april >> 14 2009 (http://mono.ximian.com/daily/) , so im not sure where to get > to >> most recent daily anymore. >> > Fixed in trunk - r139086 > > Thanks for reporting. > > V. Varadhan > >> thanks >> >> scott >> >> Veerapuram Varadhan wrote: >> > >> > 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://na> >> >> > >> 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 >> > >> > > > -- > Veerapuram Varadhan <[email protected]> > > _______________________________________________ > 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-tp24707463p24739967.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
