SQLite Forum

TEXT values can contain arbitrary binary data
Login
To add to the other posters very correct replies, I'd like to point out that this is true of most (maybe even all) DB engines.

If in MySQL you do the same thing:  

```
CREATE TABLE IF NOT EXISTS test_table (
  some_text text NOT NULL
);

INSERT INTO test_table VALUES (CONCAT(0xff, 'bork'));

SELECT some_text FROM test_table;


```

You get pretty much the same stuff back:
  some_text
  --------
  ´┐Żbork

(or, if you run it in a thing that can display those characters):
  some_text
  --------
  ├┐bork