AW: [sqlite] storing funky text in TEXT field

2007-04-05 Thread Michael Ruck
. Mike -Ursprüngliche Nachricht- Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Im Auftrag von P Kishor Gesendet: Donnerstag, 5. April 2007 20:19 An: sqlite-users@sqlite.org Betreff: Re: [sqlite] storing funky text in TEXT field On 4/5/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]>

Re: [sqlite] storing funky text in TEXT field

2007-04-05 Thread P Kishor
On 4/5/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: "P Kishor" <[EMAIL PROTECTED]> wrote: > > But, the line I quoted in my OP, namely "TEXT. The value is a text > string, stored using the database encoding (UTF-8, UTF-16BE or > UTF-16-LE)." is confusing me. What is this "database encoding" an

Re: [sqlite] storing funky text in TEXT field

2007-04-05 Thread drh
"P Kishor" <[EMAIL PROTECTED]> wrote: > > But, the line I quoted in my OP, namely "TEXT. The value is a text > string, stored using the database encoding (UTF-8, UTF-16BE or > UTF-16-LE)." is confusing me. What is this "database encoding" and > where do I have to tackle this? > > Do I have to tur

Re: [sqlite] storing funky text in TEXT field

2007-04-05 Thread P Kishor
UTF-16, or one of the 16 variants, BE/LE? - Original Message From: P Kishor <[EMAIL PROTECTED]> To: sqlite-users@sqlite.org Sent: Thursday, April 5, 2007 7:39:33 AM Subject: [sqlite] storing funky text in TEXT field Seems like a basic question, but I can't figure out a definitive answer

Re: [sqlite] storing funky text in TEXT field

2007-04-05 Thread Clark Christensen
u run the risk of a user forcing the browser's encoding to something other than what you intended. -Clark - Original Message From: P Kishor <[EMAIL PROTECTED]> To: sqlite-users@sqlite.org Sent: Thursday, April 5, 2007 7:39:33 AM Subject: [sqlite] storing funky text in TEXT fie

[sqlite] storing funky text in TEXT field

2007-04-05 Thread P Kishor
Seems like a basic question, but I can't figure out a definitive answer to this. I want to store UTF-8 characters in a TEXT field, y'know, things like umlauts and accents and that Norwegian slashed-O thingy, perhaps even South Asian Devnagari. The documentation says about text -- "TEXT. The value