Hi, I am a newbie to sqlite. I want to create a sqlite database in Linux OS.
The data that I wish to put in the table contains both ASCII and UTF-16 encoded strings. For eg. File and directory names are UTF-16 where the URL, date time information about the files are in ASCII. How do I create a table that holds both ASCII and UTF-16 strings. The documentation says that TEXT datatype can hold both the encodings, if i do a sqlite3_open -> TEXT is only ASCII, UTF-8 if i do a sqlite3_open16 -> TEXT is only UTF-16 Thanks in advance. ________________________________________________________________________ You are invited to Get a Free AOL Email ID. - http://webmail.aol.in _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
