On 4 Jun 2017, at 9:05pm, Shane Dev <[email protected]> wrote: > Why can't I display these Unicode characters from sqlite3 command line > utility?
Windows Console doesn’t support multibyte characters: <https://msdn.microsoft.com/en-us/library/windows/desktop/dd317752(v=vs.85).aspx> "many legacy applications continue to use character sets based on code pages. Even new applications sometimes have to work with code pages, often for one of the following reasons: • To communicate with legacy applications. • To communicate with older mail and news servers, which might not always support Unicode. • To communicate with the Windows Console, which does not support Unicode." See the third bulletpoint. PowerShell won’t display Unicode correctly because it is limited to fonts which don’t have Unicode glyphs. Even if you were to hack it to display in other fonts, I don’t know whether PowerShell handles multibyte characters correctly internally. (The current version of PowerShell might have fixed this. Does anyone know ?) Please note also that other parts of Windows do not handle multibyte characters correctly for other functions. For instance, some versions of Windows convert Unicode to ASCII in pipes. So you would even get errors when piping output from sqlite3 to a file. Can confirm that your examples word fine on a Macintosh, outputting the unicode characters you’d expect to see, just like Linux. Simon. _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
