MSCEWI2012

Binary does not support default.

Severity

Low

Description

This message is shown when SnowConvert finds a data type BINARY along with a DEFAULT value specification. Since default values are not allowed in BINARY columns, it is removed and a warning is added.

Code Example

Input Code:

CREATE TABLE TableExample
(
ColumnExample BINARY DEFAULT '00000000'XB NOT NULL
)

Output Code:

CREATE TABLE PUBLIC.TableExample
(
ColumnExample BINARY NOT NULL /*** MSC-WARNING - MSCEWI2012 - BINARY DOES NOT SUPPORT DEFAULT '00000000'XB ***/
);

Recommendations

  • No additional user actions are required.

  • For more support, you can email us at [email protected] or post a message to our forums. If you have a contract for support with Mobilize.Net, reach out to your sales engineer and they can direct your support needs.