RE: [sqlite] Unicode support for Sqlite?
Thankyou all for the quick replies. Best Regards, A.Sreedhar. -Original Message- From: Trevor Talbot [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 12, 2007 5:08 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Unicode support for Sqlite? On 12/12/07, Sreedhar.a <[EMAIL PROTECTED]> wrote: > I am using the sqlite to store the metadata of audio files. > Is it possible to store the metadata in unicode character format in sqlite. Yes; SQLite assumes all TEXT type data in the database is Unicode. You can work with it in UTF-8 with the *_text() APIs, or UTF-16 using the *_text16() calls. SQLite will convert between the two encodings as necessary. The sqlite3 shell assumes UTF-8, but it depends on the platform's console to actually use UTF-8 when talking to it, so it may be difficult to properly test with it. - To unsubscribe, send email to [EMAIL PROTECTED] - - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] Unicode support for Sqlite?
On 12/12/07, Sreedhar.a <[EMAIL PROTECTED]> wrote: > I am using the sqlite to store the metadata of audio files. > Is it possible to store the metadata in unicode character format in sqlite. Yes; SQLite assumes all TEXT type data in the database is Unicode. You can work with it in UTF-8 with the *_text() APIs, or UTF-16 using the *_text16() calls. SQLite will convert between the two encodings as necessary. The sqlite3 shell assumes UTF-8, but it depends on the platform's console to actually use UTF-8 when talking to it, so it may be difficult to properly test with it. - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] Unicode support for Sqlite?
utf-8 and utf-16 ARE unicode formats. But there are some things that sqlite does not handle without the ICU extension. The ICU extension extends SQLite with the following functionallity: 1.1 SQL Scalars upper() and lower() 1.2 Unicode Aware LIKE Operator 1.3 ICU Collation Sequences 1.4 SQL REGEXP Operator Download the SQLite source and have a look in the ext/icu directory Sreedhar.a wrote: Hi, Does Sqlite support unicode? I have seen that it supports utf-8 and utf-16. I want to know whether it supports unicode character formats. Thanks and Best Regards, A.Sreedhar. - To unsubscribe, send email to [EMAIL PROTECTED] -
RE: [sqlite] Unicode support for Sqlite?
Hi, I am using the sqlite to store the metadata of audio files. Is it possible to store the metadata in unicode character format in sqlite. Best Regards, A.Sreedhar. -Original Message- From: Trevor Talbot [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 12, 2007 4:40 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Unicode support for Sqlite? On 12/12/07, Sreedhar.a <[EMAIL PROTECTED]> wrote: > Does Sqlite support unicode? > I have seen that it supports utf-8 and utf-16. > I want to know whether it supports unicode character formats. Unicode is a very large and complex topic, so that question is way too vague to answer. Can you provide an example of what you're looking for? - To unsubscribe, send email to [EMAIL PROTECTED] - - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] Unicode support for Sqlite?
On 12/12/07, Sreedhar.a <[EMAIL PROTECTED]> wrote: > Does Sqlite support unicode? > I have seen that it supports utf-8 and utf-16. > I want to know whether it supports unicode character formats. Unicode is a very large and complex topic, so that question is way too vague to answer. Can you provide an example of what you're looking for? - To unsubscribe, send email to [EMAIL PROTECTED] -
[sqlite] Unicode support for Sqlite?
Hi, Does Sqlite support unicode? I have seen that it supports utf-8 and utf-16. I want to know whether it supports unicode character formats. Thanks and Best Regards, A.Sreedhar.