CREATE TABLE animals (
    id INTEGER NOT NULL PRIMARY KEY,name TEXT NOT NULL
);

INSERT INTO animals (name) VALUES ('Monkey');
INSERT INTO animals (name) VALUES ('manatee');

SELECT name FROM animals ORDER BY name;

name      
----------
Monkey    
manatee

我希望自然地对结果进行分类(即海牛,猴子). sqlite没有这样排序的选项吗？我对大量数据进行了排序,如果sqlite无法自然排序,我认为解决方案是回到Postgresql或MysqL.