title: 1064 - Syntax error near 'NUMBER NOT NULL default' 0.0 ',
body: <p>I cannot create a table with the SQL instructions below</p>
  
  <p>I've tried to modify some de fault values but I have the same error.</p>
  
  <pre><code>DROP TABLE IF EXISTS CountryLanguage;
  CREATE TABLE CountryLanguage (
    CountryCode TEXT NOT NULL DEFAULT '',
    Lang TEXT NOT NULL DEFAULT '',
    IsOfficial INTEGER NOT NULL DEFAULT '0',
    Percentage NUMBER NOT NULL default '0.0',
    PRIMARY KEY  (CountryCode,Lang)
  );
  </code></pre>
  
  <p>Table is not created and I have the message below:</p>
  
  <pre><code>Static analysis:
  
  1 errors found during the scan.
  
  Data type not recognized. (near "NUMBER" in position 164)
  
  SQL request: CREATE TABLE CountryLanguage ( CountryCode TEXT NOT NULL DEFAULT '', Lang TEXT NOT NULL DEFAULT '', IsOfficial INTEGER NOT NULL DEFAULT '0', Percentage NUMBER NOT NULL default '0.0', PRIMARY KEY (CountryCode,Lang) )
  
  MySQL replied: Documentation
  # 1064 - Syntax error near 'NUMBER NOT NULL default' 0.0 ',
     PRIMARY KEY (CountryCode, Lang)
  ) 'at line 5
  </code></pre>