[Mono-list] Empty string saved as null in sql server

Nagappan Alagappan nagappan at gmail.com
Tue Jul 28 17:45:43 EDT 2009


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 <Scott.Fluto at cmgl.ca> 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 <Scott.Fluto at cmgl.ca> 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  -  Mono-list at lists.ximian.com
> >> 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  -  Mono-list at lists.ximian.com
> > 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  -  Mono-list at lists.ximian.com
> http://lists.ximian.com/mailman/listinfo/mono-list
>



-- 
Linux Desktop (GUI Application) Testing Project -
http://ldtp.freedesktop.org
http://nagappanal.blogspot.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.ximian.com/pipermail/mono-list/attachments/20090728/5b314ae3/attachment.html 


More information about the Mono-list mailing list