Re: [sqlite] Cyrillic support

Hello Jean-Christophe, Good point. My application is 100% UTF-8 so, I probably think in just UTF-8. C Saturday, March 10, 2012, 4:38:00 PM, you wrote: >>You just need to convert it to UTF-8 before insert, then convert it >>back when you pull the data. >> >>UTF-16->UTF8 - insert >>Select -

Re: [sqlite] What's the best way to organize this database?

On 9 Mar 2012, at 4:00pm, John Salerno wrote: > On Fri, Mar 9, 2012 at 7:29 AM, Simon Slavin wrote: > >> Sooner or later you're going to want to make a list which is sorted in >> artist order. And you're going to want to list 'The Beatles' (if you

Re: [sqlite] What's the best way to organize this database?

On Fri, Mar 9, 2012 at 7:29 AM, Simon Slavin wrote: > Sooner or later you're going to want to make a list which is sorted in artist > order.  And you're going to want to list 'The Beatles' (if you have any taste > at all).  But if you list artists in name order they'd

Re: [sqlite] Cyrillic support

You just need to convert it to UTF-8 before insert, then convert it back when you pull the data. UTF-16->UTF8 - insert Select - UTF8->UTF16 There are 16-bit SQLite APIs for that, no conversion needed actually. But of course it all depends of the wrapper you use, if any.

Re: [sqlite] Cyrillic support

Hello Mite, You just need to convert it to UTF-8 before insert, then convert it back when you pull the data. UTF-16->UTF8 - insert Select - UTF8->UTF16 Or whatever encoding you use. I insert and retrieve full asian languages using UTF-8 conversions. You should be using UTF-8 for

Re: [sqlite] Cyrillic support

I am using the newest version of SQLite. How do I enable support for Cyrillic letters? Whenever I enter something in the DB with Cyrillic letters it gets saved like this ?? This would happen if your Unicode Cyrillic text gets "converted" (read "emasculated") to ANSI using a non-cyrillic

Re: [sqlite] Cyrillic support

On 10.03.2012 19:07, Mite wrote: I am using the newest version of SQLite. How do I enable support for Cyrillic letters? Whenever I enter something in the DB with Cyrillic letters it gets saved like this ?? I don't think so. Please try the attached shell script. Also, you can check this

[sqlite] Cyrillic support

I am using the newest version of SQLite. How do I enable support for Cyrillic letters? Whenever I enter something in the DB with Cyrillic letters it gets saved like this ?? Thanks ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] Database not readable anymore

On Fri, 09 Mar 2012 11:58:12 +0100, Dirk Geppert wrote: >Dear Ladies and gentlemen, I am sending you an sqlite file, >that is just not readable anymore. Attachments usually don't make it to the mailing list. It's better to put the file online somewhere and provide a link

Re: [sqlite] SIGBUS error in case of disk full with WAL mode

On Sat, 10 Mar 2012 10:25:10 +0900, Yongil Jang wrote: >Following sentences are found on sqlite source. >And, there is a comment about database corruption. >Could I get more detailed explanation about this? > >The use of the SQLITE_SHM_DIRECTORY compile-time >** option

Re: [sqlite] Building an SQLite Extension: How to check if a table exists in the database?

Try this SELECT * FROM dbname.sqlite_master WHERE type='table' AND name='tbname'; Change dbname with name of your database and tbname with the name of table. -- speco > To: sqlite-users@sqlite.org > From: itandet...@mvps.org > Date: Fri, 9 Mar 2012 20:30:55 -0500 > Subject: Re:

Re: [sqlite] TEXT PRIMARY KEY

2012/3/9 Christoph P.U. Kukulies : CREATE TABLE instance  (          path TEXT,          basename TEXT,          size INT,          md5sum TEXT,          creation_date TEXT,          last_write_time TEXT, FOREIGN KEY (md5sum) REFERENCES resource (md5sum)          );