On On, 2006-07-05, 17:08, Dotan Cohen skrev: > Allright, I built F-spot with the latest patch, and it does work! All > the photos have tags. >
Great news :) > My last issue is work out on my way to happily presenting the wife > with a working photo manager is converting the tags from their unusual > encoding to Hebrew. I installed sqlite, sqlite3 and sqlitebrowser with > the intention of working directly on the tags in photos.db but I've no > luck. I'm not sure if this list is the right place to ask about SQL > queries, so I'll subscribe to the sqlite list (assuming there is one) > if I can't ask here. > > What is the SQL command for converting all instances of "needle" to > "new_needle"? I specifically need to work on a letter-to-letter basis, > changing for instance the character string > "\u05D0\u05D1\u05D2\u05D3\u05D4" to "abcde" (well, the Hebrew > equivelent of abcde). > Could you also send a link to a photo with Hebrew tags? perhaps check this site for some sample. http://sqlrelay.sourceforge.net/sqlrelay/gettingstarted/sqlite.html In particular sqlite> update testtable set col2=0 where col1='hi'; with other words sqlite> update TAGNAME_DB set NAME='new_name' where NAME='name'; Dont have f-spot at hand, so you will have to change database, and column name. you can also check http://www.sqlite.org/lang_update.html _______________________________________________ F-spot-list mailing list [email protected] http://mail.gnome.org/mailman/listinfo/f-spot-list
