On Sat, 15 Jan 2005 10:51:03 -0400, LIN, Ming Q. <[EMAIL PROTECTED]> wrote:
> I am new to sqlite, I am using it for my unicode project in windows > platform. In windows, Unicode uses wchar variable, but it looks like the > sqlite only take char for parameters. Do anyone know how to store unicode > (such as chinese, japanese) in sqlite. I am using visual studio 2003 and > windows 2000 OS. I store Japanese in SQLite databases all the time, as UTF8. If you want to be able to use LIKE to search for UTF8 text, then you'll need to build SQLite with UTF8 support. Unless, of course, you are using SQLite 3, which handles, I believe, both UTF8 and UTF16 out of the box.
