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 -
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 have
>> any taste at all). But if you list
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 come in the Ts, not
> the
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.
__
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 yo
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 c
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 out
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
http://sqlite.or
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 here.
>All the tools l
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 results in an incompati
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: [sq
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)
);
CREATE TABLE resource
12 matches
Mail list logo