Skip to content

Delphi Data Access Components

Delphi Data Access Components is a line of DB connectivity solutions for such databases as: Oracle, Microsoft SQL Server, MySQL, InterBase, Firebird, PostgreSQL, SQLite, Microsoft Access, DB2, Sybase Advantage Database Server, Sybase Adaptive Server Enterprise, and other databases (using ODBC provider).

Delphi Data Access Components



  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback

41 results found

  1. Some databases allow saving an empty string optionally as NULL or as empty string. Query result can differ depending on how the string was saved.

    select *
    from test_table
    where str is null
    will return strings that were saved as NULL values

    select *
    from test_table
    where str = ''
    will return strings that were saved as empty strings

    We can add an EmptyStringAsNull option, which will force saving empty strings as NULL values.

    24 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    completed  ·  0 comments  ·  Common  ·  Admin →
1 3 Next →
  • Don't see your idea?