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.

MSCEWI2011

MSCEWI2013

Last modified 1yr ago