[Gambas-user] SQL NULL vs empty when difference not when insert

[PICCORO McKAY Lenz]

i see in the wiki data mapping that Gambas always stores NULL in the
database, never a void string, so i ask if analoges and contray of the wiki
example can work too or are differend, i mean:

For example, this can work:

SELECT * FROM table WHERE name <> '';

Take with care the "<>" ad "diference of" that are valid in DB SQL ANSI:

SELECT * FROM table WHERE name <> NULL;

at DBMS level, i dont think so that  " name <> NULL" witll be same as "name
<> ''"

MY QUESTION IN FACT IS: independent of how gambas store the data, if i made
the query, will assume NULL and '' as same, and both querys are valid of
different (comparing again null or '' but with "<>" event with "=")

reding the wiki due i work with many DBMS not popular (not mysql-baby cry)

Lenz McKAY Gerardo (PICCORO)
http://qgqlochekone.blogspot.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.gambas-basic.org/pipermail/user/attachments/20180525/22c0d77b/attachment.html>