Empty string behaviour...

[krofak]

Today, I noticed different empty string behaviour then I am
used to.

Before, empty string was treated as null, so statement

vcResult := 'something' || ''

would result in vcResult = ''.

Today, result of this statement was vcResult = 'something'.

Does anybody know, when (which patchset) did this behaviour
with treating empty strings as null change?

--
I find myself fascinating.

[HansF]

On Thu, 20 Oct 2005 21:17:59 +0200, krofak interested us by writing:

Does anybody know, when (which patchset) did this behaviour
with treating empty strings as null change?

Seems to work (something+'' = something) in 9.0.1.3.1

It would be somewhat useful for you to tell us the version and patchset
you are on, as well as the OS info.

--
Hans Forbrich
Canada-wide Oracle training and consulting
mailto: Fuzzy.GreyBeard_at_gmail.com
*** I no longer assist with top-posted newsgroup queries ***

[Frank van Bortel]

krofak wrote:

Today, I noticed different empty string behaviour then I am
used to.

Before, empty string was treated as null, so statement

vcResult := 'something' || ''

would result in vcResult = ''.

Today, result of this statement was vcResult = 'something'.

Does anybody know, when (which patchset) did this behaviour
with treating empty strings as null change?

--
I find myself fascinating.

Not in Oracle... An empty string in Oracle is NULL.
NULL concatenated to s string is that string (nothing more,
nothing less).

I find you less fascinating; you obviously post in the
wrong group.
--
Regards,
Frank van Bortel

Top-posting is one way to shut me up...

[krofak]

"HansF" <Ne*******@telus.net> wrote in message
news:pa****************************@telus.net...

On Thu, 20 Oct 2005 21:17:59 +0200, krofak interested us by writing:

Does anybody know, when (which patchset) did this behaviour
with treating empty strings as null change?

Seems to work (something+'' = something) in 9.0.1.3.1

It would be somewhat useful for you to tell us the version and patchset
you are on, as well as the OS info.

Version: 9.2.0.7. I am not sure about OS, AIX something