Wow! Excellent summary, Trevor.
- Original Message
From: Trevor Talbot <[EMAIL PROTECTED]>
To: sqlite-users@sqlite.org
Sent: Thursday, September 20, 2007 11:35:42 PM
Subject: Re: [sqlite] SQLite and html character entities
On 9/20/07, P Kishor <[EMAIL PROTECTED]> wrote:
I should also mention, a text editor I like to use is SubEthaEdit (I
have the old 2.2 version), and it supports switching encodings via the
Format menu. If you're switching to find the encoding of an existing
file, just choose Reinterpret when it asks.
On 9/20/07, P Kishor <[EMAIL PROTECTED]> wrote:
> On 9/20/07, Trevor Talbot <[EMAIL PROTECTED]> wrote:
> > On 9/20/07, P Kishor <[EMAIL PROTECTED]> wrote:
> > > Lucknow:~/Data/ecoservices punkish$ less foo.csv
> > > "the first record"
> > > "\351 \347 \361 \356"
> > > "more from 3rd row"
> > > "ro
On 9/20/07, Trevor Talbot <[EMAIL PROTECTED]> wrote:
> On 9/20/07, P Kishor <[EMAIL PROTECTED]> wrote:
>
> > sqlite> select * from tbl;
> > the first record
> > é ç ñ î
> > more from 3rd row
> > row four
> > these "volunteered" activities
> > <á ø ã ü î & others>
> > -
>
On 9/20/07, P Kishor <[EMAIL PROTECTED]> wrote:
> sqlite> select * from tbl;
> the first record
> é ç ñ î
> more from 3rd row
> row four
> these "volunteered" activities
> <á ø ã ü î & others>
> -
> sqlite> .mode csv
> sqlite> .output foo.csv
> sqlite> select * from tbl
it back to the browser, does it display
correctly?
-Clark
- Original Message
From: P Kishor <[EMAIL PROTECTED]>
To: sqlite-users@sqlite.org
Sent: Thursday, September 20, 2007 9:12:30 AM
Subject: Re: [sqlite] SQLite and html character entities
On 9/20/07, Clark Christensen &
e.org
> Sent: Thursday, September 20, 2007 6:43:37 AM
> Subject: Re: [sqlite] SQLite and html character entities
>
> Thanks Nuno. Since I am raw in this matter, could I ask you for a
> little more hand-holding as specified below --
>
> On 9/20/07, Nuno Lucas <[EMAIL PROTECT
ite.org
Sent: Thursday, September 20, 2007 6:43:37 AM
Subject: Re: [sqlite] SQLite and html character entities
Thanks Nuno. Since I am raw in this matter, could I ask you for a
little more hand-holding as specified below --
On 9/20/07, Nuno Lucas <[EMAIL PROTECTED]> wrote:
> You have t
Thanks Nuno. Since I am raw in this matter, could I ask you for a
little more hand-holding as specified below --
On 9/20/07, Nuno Lucas <[EMAIL PROTECTED]> wrote:
> You have to know the encoding of the user input. To do that, all your
> html forms _MUST_ have proper tags, and as you will be using
You have to know the encoding of the user input. To do that, all your
html forms _MUST_ have proper tags, and as you will be using
SQLite, the obvious encoding choice will be UTF-8 (because that way
you don't need to do any conversions when feeding/retrieving data
to/from SQLite).
Then there is t
Folks,
I come to ask you a question that may be basic for many of you but is
leaving me completely bewildered. My work environment is a Mac OS X
(Tiger) computer, and I use a Cocoa-based text editor, and am writing
a Perl-based web app. Data are in several different languages,
predominantly Englis
11 matches
Mail list logo