Announcement

Collapse
No announcement yet.

missing values - blank vs null

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • missing values - blank vs null

    ANSI SQL won't save a blank as a missing value in a numeric field; MySQl does (ugh!); unfortunately Excel doesn't differentiate. If we could save the choice made in the import wizard's Please select a desired import mode. - Advanced option stick as the default going forward, it would help. Similar problem with blank text fields; missing values, and blanks in enumerated columns.

    Really love V12! Nice work!

    Liston

  • #2
    Hi Liston,

    Do you mean you want set the "Use Empty String as NULL" option to default enabled?

    Also, could you please provide your Navicat version? e.g. Navicat for MySQL (Windows) 12.0.10 64-bit

    Comment

    Working...
    X