SQLite Forum

PRINTF - newlines, tabs etc?
Login
From the [docs](https://www.sqlite.org/printf.html) I understand that SQLite has its own implementation of 'printf', rather than matching the C implementation. - so it can provide some more specific formatting options. 

But is there something fundamental about the way this is written that precludes the use of escaped characters for TAB "\\t" , newline "\\n" etc? (maybe platform independence issues with this?)

I found a workaround, so not a huge problem - but just more wordy and less standard:

```
SELECT PRINTF("x%cx",char(9)) -- works, just not the same in C (etc)
INTERSECT
SELECT PRINTF("x\tx")
-- no rows: "\t" is returned literally rather than outputting a TAB.
```