Re: [sqlite] Cyrillic support

[Alek Paunov]

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 if add a bookmark for any page with 
Cyrillic title in your Firefox, then look at the db: places.sqlite in 
your Firefox profile, table: moz_bookmarks, column: title (last row).

Alek
#/bin/sh

n0=cyrtest-0.txt
n1=cyrtest-1.txt

echo "Текст на кирилица" > $n0

(

        echo "create table cyrtest(c text);"
        echo "insert into cyrtest(c) values ('$(cat $n0)');"
        echo "select c from cyrtest;"

) | sqlite3 cyrtest.sqlite > $n1


diff $n0 $n1
if [ $? -eq 0 ]; then
        echo "$n0 and $n1 are identical"
fi
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users