SQL and other databases

[Bob Sneidar]

Yes but those are numeric data types. The restriction was on the char types char() and varchar() (if I am not mistaken). TEXT types do not allow defaults at all according to the manual. 

Bob


On Mar 22, 2011, at 10:29 AM, Peter Haworth wrote:

> Hi Bob,
> I'm slowly putting together a list of differences between SQLite and MySQL.  I'm concentrating on things that SQLite allows and MySQL does not.  I haven't looked at extra functionality provided by MySQL over and above what SQLite provides since right now I just want to get to the point that my SQLite schema definitions and data manipulation statements work in MySQL
> 
> Before getting to the list, a couple of observations on the issues you've come across.  
> 
> I'm not seeing the requirement to have NOT NULL in conjunction with DEFAULT.  Here's a snippet which was accepted just fine by mySQL:
> 
> `BandTrakSalesID` int(11) DEFAULT '0',
>  `Selected` tinyint(1) DEFAULT '1',