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

Gunter Sent: Wednesday, June 15, 2016 4:21 PM To: 'SQLite mailing list' Subject: Re: [sqlite] Latin-1 characters cannot be supported for Unicode The answer is very simple: Do not use ANSI/ISO encoding with SQLite. SQLite expects Unicode. -Ursprüngliche Nachricht- Von: sqlite-

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

: Wednesday, June 15, 2016 4:21 PM To: 'SQLite mailing list' Subject: Re: [sqlite] Latin-1 characters cannot be supported for Unicode The answer is very simple: Do not use ANSI/ISO encoding with SQLite. SQLite expects Unicode. -Ursprüngliche Nachricht- Von: sqlite-

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

An: SQLite mailing list Betreff: Re: [sqlite] Latin-1 characters cannot be supported for Unicode Under the ANSI encoding environment, I created a table named TEST_PRODUÇÃO in the database. Then I opened this database with sqlite-tool. I ran the sql statement to query all the tables and found

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

On 15 Jun 2016, at 3:44am, Wang, Wei wrote: > Under the ANSI encoding environment, I created a table named TEST_PRODUÇÃO in > the database. All strings handled by SQLite, including the strings that make up SQL commands like "CREATE TABLE ...", are Unicode strings. If you are constructing an

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

, 2016 4:20 PM To: SQLite mailing list Subject: Re: [sqlite] Latin-1 characters cannot be supported for Unicode Hi Wei Wang, Did you populate the database from the sqlite3 CLI tool, your own C program, or from another language? Do you see this when you create a database from scratch, if you use a

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

lists.sqlite.org > Subject: 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

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

] Latin-1 characters cannot be supported for Unicode At 09:22 08/06/2016, you wrote: >A 3 Byte Sequence 0xFFFEC4 when converting 0xC4 to UTF-8 in UltraEdit This 3-byte sequence is neither UTF8 or UTF16 even if the BOM would make us believe it is UTF16-LE. UTF16 implies 16-bit encoding units, so

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

At 09:22 08/06/2016, you wrote: A 3 Byte Sequence 0xFFFEC4 when converting 0xC4 to UTF-8 in UltraEdit This 3-byte sequence is neither UTF8 or UTF16 even if the BOM would make us believe it is UTF16-LE. UTF16 implies 16-bit encoding units, so an odd byte length is impossible. You probably mea

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

endet: Mittwoch, 08. Juni 2016 03:49 An: SQLite mailing list Betreff: 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, W

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 i

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

] On Behalf Of Igor Tandetnik Sent: Tuesday, June 07, 2016 10:20 PM To: sqlite-users@mailinglists.sqlite.org Subject: 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 inserte

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

-users@mailinglists.sqlite.org Betreff: [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

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 showing you the conten

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 t

[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 were