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

srf Scott.Fluto at cmgl.ca
Thu Jul 30 11:03:27 EDT 2009


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 <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://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  -  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
>> >> > 
>> >> > 
>> >> 
>> > 
>> > _______________________________________________
>> > Mono-list maillist  -  Mono-list at lists.ximian.com
>> > http://lists.ximian.com/mailman/listinfo/mono-list
>> > 
>> > 
> 
> -- 
> Veerapuram Varadhan <vvaradhan at novell.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-tp24707463p24739967.html
Sent from the Mono - General mailing list archive at Nabble.com.



More information about the Mono-list mailing list