SQLite, ASCII Characters 0x20 to 0x7E Check Constraint
In SQL, \ is not a special character.

You have to insert the characters directly:

CREATE TABLE test
(
    id INTEGER NOT NULL, 
    name TEXT NOT NULL CHECK(name NOT GLOB '*[^ -~]*'),
    PRIMARY KEY(id)
)