SQL and other databases

[Bob Sneidar]

Then it may be engine specific. My query produced an error when trying to create a table in my On-Rev database if I specified a default for varchar columns without using NOT NULL. After adding NOT NULL it worked fine. 

Bob


On Mar 22, 2011, at 12:21 PM, Peter Haworth wrote:

> Not seeing it on those types either:
> 
> `testdefault` char(10) DEFAULT 'XYZ',
> `testdefault2` varchar(10) DEFAULT 'ABC',
> 
> Worked fine for me (through Sequel Pro).  I wonder if this is a difference between versions of MySQL.  I'm using the Community version which is the free one.
> 
> You're right on the TEXT types not allowing defaults although why that should be is a mystery.  
> 
> Pete Haworth
> 
> On Mar 22, 2011, at 11:54 AM, Bob Sneidar wrote:
> 
>> 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',
>> 
>> 
>> _______________________________________________
>> use-livecode mailing list
>> use-livecode at lists.runrev.com
>> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
>> http://lists.runrev.com/mailman/listinfo/use-livecode
>> 
> 
> 
> _______________________________________________
> use-livecode mailing list
> use-livecode at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode