Sorry i think i'd might have raised a false alarm, after further check on postgres forum i found this:
" It's just a data visualization problem, the field actually contains an empty string and each and every program that accesses that row will get an empty string. I suspect you get that in PgAdmin, and it's a way of telling you it's an empty string and not a null. " A comment from one of the forumer. Thanx and sorry for the trouble. FooShyn On Tue, Mar 27, 2012 at 1:51 AM, Jacques Le Roux < [email protected]> wrote: > I think there is something wrong in your code. > At least this is not intended (could be an OOTB bug I mean) > > Jacques > > From: "Foo Shyn Chung" <[email protected]> > > Hi all, >> >> I'm using Ofbiz 11.04 branch as the base for my project currently. The >> database i'm using is Postgres. >> >> In one of the module, due to the restriction of using the service, i need >> to use Java Events to retrieve the value from a form and save it into the >> database. I'm using the delegator to store the value to the database. >> (delegator.create and delegator.storeAll) >> >> I notice that whenever a database column is of text type, if the field is >> empty or null during the transaction, the value stored into the database >> will be 2 single quotes: '' >> >> There's no such issue when i use service to store value in other module. >> Is >> this intentional, a bug or I did something wrong that provoked such >> problem? >> >> Appreciate any pointers. >> >> Thanx >> FooShyn >> >>
