On 9/14/07, Asif Lodhi <[EMAIL PROTECTED]> wrote: > Hi, > > I've been just glancing over the Unicode related posts. However, I > would like to know how it's possible for me to insert text in > different languages in an Sqlite database. Can you fixate the "type" > of the language for any particular database? I would be thankful if > any of you guys could explain to me the procedure in a step-by-step > manner.
SQLite holds UTF-8 or UTF-16 text, and converts between the two. That is as far as SQLite's Unicode support goes - if you would like to index/sort text according to a language you will need to give it a custom collation (which is not hard) otherwise it will use an ordinal comparison. -- Cory Nelson ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------