Re: [sqlite] Latin-1 characters cannot be supported for Unicode

On 6/7/2016 9:49 PM, Wang, Wei wrote: Thanks for your reply! But I found the Latin-1 encoded characters are listed in the Unicode chart. http://unicode.org/charts/PDF/U0080.pdf All the characters available in Latin-1 codepage are indeed also available in Unicode. However, the same character

Re: [sqlite] Latin-1 characters cannot be supported for Unicode

Thanks for your reply! But I found the Latin-1 encoded characters are listed in the Unicode chart. http://unicode.org/charts/PDF/U0080.pdf Best Regards, Wang Wei -Original Message- From: sqlite-users-boun...@mailinglists.sqlite.org [mailto:sqlite-users-boun...@mailinglists.sqlite.org]

Re: [sqlite] SQL / SQLite for Beginners

That was what I was trying to say - thanks for the superior spelling. Also - for wee Java folks, I cobbled together a CRUD generator for SQLite last night: https://sourceforge.net/projects/sqlmate Also on: https://github.com/soft9000/SQLMate Sharing is caring, -Rn On Tue, Jun 7, 2016

Re: [sqlite] UPDATE statement without FROM clause

Hi, of course there is in general a difference between syntax complexity and performance but unfortunately not in this case. And the „just“ is very often the most difficult part. Regards, Hartwig > Am 2016-06-07 um 07:39 schrieb James K. Lowden : > > On Sat, 4 Jun

Re: [sqlite] Latin-1 characters cannot be supported for Unicode

As already stated, this is not a problem of SQLite. SQLite assumes all input to be correctly encoded in UTF (unicode), the precise flavor of which may be set (once, between creating a db file and the first insert) by a pragma. If you insert ISO (latin) encoded strings, SQLite will faithfully

Re: [sqlite] Latin-1 characters cannot be supported for Unicode

On 7 Jun 2016, at 8:43am, Wang, Wei wrote: > Then I opened the database with SQLite Developer. SQLite Developer is not supported by the team which wrote SQLite. It's just a program which uses SQLite. If it allows you to pick character encoding then it is not correctly

Re: [sqlite] Latin-1 characters cannot be supported for Unicode

On 6/7/2016 3:43 AM, Wang, Wei wrote: I met a problem that was maybe caused by the encoding of SQLite. I inserted a item which including some Latin1 characters like Ç and à into a table. Then I opened the database with SQLite Developer. After I setting the encoding to ANSI, the display and

[sqlite] [BugReport]Data changes cannot actually flush to disk

Dear SQLite developers, Sqlite version: 3.8.8.3 Linux version: 3.10.31-ltsi Problem: When update database and power off immediately, it cannnot actually make changes to database file in the disk. Although the HAVE_FDATASYNC comile-time option is true. If manually called sync() after executing

[sqlite] Latin-1 characters cannot be supported for Unicode

Hi, I met a problem that was maybe caused by the encoding of SQLite. I inserted a item which including some Latin1 characters like Ç and à into a table. Then I opened the database with SQLite Developer. After I setting the encoding to ANSI, the display and the query result for that table