Empty string behaviour...

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • krofak
    #1

    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.


    Tags: None
    • HansF
      #2
      Re: Empty string behaviour...

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

        Comment

        • Frank van Bortel
          #3
          Re: Empty string behaviour...

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

            Comment

            • krofak
              #4
              Re: Empty string behaviour...


              "HansF" <News.Hans@telu s.netwrote in message
              news:pan.2005.1 0.20.20.14.53.7 03819@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


                Comment

                Previous template Next
                Working...