Empty string behaviour...

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.

re: Empty string behaviour...

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

[color=blue]
> Does anybody know, when (which patchset) did this behaviour
> with treating empty strings as null change?[/color]

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 ***

re: Empty string behaviour...

krofak wrote:[color=blue]
> 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.
>
>[/color]

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...

re: Empty string behaviour...

"HansF" <News.Hans@telus.net> wrote in message
news:pan.2005.10.20.20.14.53.703819@telus.net...[color=blue]
> On Thu, 20 Oct 2005 21:17:59 +0200, krofak interested us by writing:
>
>[color=green]
>> Does anybody know, when (which patchset) did this behaviour
>> with treating empty strings as null change?[/color]
>
> 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.[/color]

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