Re: [sqlite] Encoding question

2015-02-02 Thread RSmith
On 2015/02/02 19:37, Peter Haworth wrote: On Mon, Feb 2, 2015 at 9:00 AM, wrote: From: RSmith To: sqlite-users@sqlite.org Subject: Re: [sqlite] Encoding question Message-ID: <54cebb71.8060...@rsweb.co.za> Content-Type: text/plain; charset=windows-1252; format=flowed In short, the

Re: [sqlite] Encoding question

2015-02-02 Thread Richard Hipp
On 2/2/15, Peter Haworth wrote: > I should also have mentioned that the question also included table names, > column names, constraint names, etc, but I'll assume the same applies to > them as for the data. > The schema is *always* in the database encoding. The SQLite parser wouldn't be able to

Re: [sqlite] Encoding question

2015-02-02 Thread Peter Haworth
On Mon, Feb 2, 2015 at 9:00 AM, wrote: > From: RSmith > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] Encoding question > Message-ID: <54cebb71.8060...@rsweb.co.za> > Content-Type: text/plain; charset=windows-1252; format=flowed > > In short, the UTF-8 Pragma

Re: [sqlite] Encoding question

2015-02-01 Thread Richard Hipp
On 2/1/15, Peter Haworth wrote: > I'm new to the unicode world so this question may not make sense. > > The "PRAGMA encoding" statement tells me the encoding of a database. Can I > rely on all data in the database having that encoding? For example, if the > encoding is UTF8 and a row is inserted c

Re: [sqlite] Encoding question

2015-02-01 Thread Stephan Beal
On Mon, Feb 2, 2015 at 12:49 AM, RSmith wrote: > guarantee that /IF/ you put valid UTF-8 data in there, it will be handled > and returned correctly). > For a given definition of "correct." A relatively common topic on this list is the handling of locale-specific collations (a topic i'm not quali

Re: [sqlite] Encoding question

2015-02-01 Thread RSmith
On 2015/02/02 01:12, Peter Haworth wrote: I'm new to the unicode world so this question may not make sense. The "PRAGMA encoding" statement tells me the encoding of a database. Can I rely on all data in the database having that encoding? For example, if the encoding is UTF8 and a row is inserte

[sqlite] Encoding question

2015-02-01 Thread Peter Haworth
I'm new to the unicode world so this question may not make sense. The "PRAGMA encoding" statement tells me the encoding of a database. Can I rely on all data in the database having that encoding? For example, if the encoding is UTF8 and a row is inserted containing UTF16 encoded data, will it stil

Re: [sqlite] Encoding Question

2011-05-31 Thread Brian Pears
Christian Schwarz wrote: >This is base64. Christian Many thanks - I've not come across this before, but there's enough in the Wikipedia article to enable me to write a little vb script to convert the base64 to text. Brian -- Brian Pears (Gateshead) __

Re: [sqlite] Encoding Question

2011-05-31 Thread Christian Schwarz
This is base64. Christian ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Encoding Question

2011-05-31 Thread Brian Pears
As you will gather I am very new to SQLite and indeed to databases in general, so please bear with me. I am using the Singular SQLiteExplorer 3.04 to examine a Rootsmagic database. When I display a particular table, right click on a particular blob cell in the "Fields" column and select "Copy