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
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
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
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
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
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
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
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)
__
This is base64.
Christian
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
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
10 matches
Mail list logo