NULL vs Empty string Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: NULL vs Empty string

  1. #1
    Join Date
    Mar 2001
    Dear all,

    In SQL cmd,
    How can we insert the Empty string into the field but
    it is not NULL.

    Best regards


  2. #2
    Join Date
    Feb 2001
    Check this link (to the 'mindbenders' section of this site)

    It explains that NULL is in fact a character string of length 0.

  3. #3
    Join Date
    Jul 2000
    Oracle makes no difference between NULL and an empty string. In the future Oracle may comply to the aspect of the ANSI SQL 1992 standard, that empty strings are not equivalent to NULL. Oracle even recommends not to treat empty strings and NULL as the same. The problem is, there is no difference in Oracle.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width