I have an sqlite3 database that I’ve been using the sqlite3 command line tool to manage, from the Glitch console. It’s great!
However, I have some columns that contain unicode, specifically emojis, and I’d like to be able to work with them.
The console seems to catch the usual “ctrl-cmd-space” that would open the OS X emoji selector, giving off a beep and not opening the selector.
If I copy an emoji character from elsewhere and paste it in, the console seems to get confused, putting in an unrelated ascii character and breaking the following string:
The console displays emoji correctly, e.g. when I search. I’m at my limit for photos-per-post as a new user, so you can find a screengrab of a working sqlite query with unicode results here
Does anyone know a workaround for this? I’d also be happy to file this as a bug report / feature request, if someone can point me in the right direction.