Re: [sqlite] Unicode Help

2006-12-07 Thread Scott Hess
On 12/7/06, Nuno Lucas <[EMAIL PROTECTED]> wrote: On 12/7/06, Da Martian <[EMAIL PROTECTED]> wrote: > Ok, that does answer one of my questions I think. If I passed something not > in UTF-8 to sqlite would it return it exactly the same way I passed it in? > From your statement of chaos below I

Re: [sqlite] Unicode Help

2006-12-07 Thread Nuno Lucas
On 12/7/06, Da Martian <[EMAIL PROTECTED]> wrote: Ok, that does answer one of my questions I think. If I passed something not in UTF-8 to sqlite would it return it exactly the same way I passed it in? From your statement of chaos below I assume it wont if that data somehow violates UTF-8. So I

Re: [sqlite] Unicode Help

2006-12-07 Thread Da Martian
Hi You seem really confused about the whole encoding issue. Yes definatly confused, I had always hope unicode would simplify the world, but my experiences have shown no such luck :-) Codepages haunted my past and encodings haunt my future :-) Ok, that does answer one of my questions I think.

Re: [sqlite] Unicode Help

2006-12-07 Thread drh
"Da Martian" <[EMAIL PROTECTED]> wrote: > When using the > NON16 version of prepare: > If I add text which is in UTF16 what happens? > > 16 Version: > If I add UTF16 text what happnes? > if I add UTF-8 Text what happens? > if I add ASCIII text what happnes? > You seem really confused about

[sqlite] Unicode Help

2006-12-05 Thread Da Martian
Hi I have a system up and working using sqlite3, but I think I am having unicode issues and I am not sure how I should go about coding the solution. I was hoping someone could share the approach needed. Here is my situation: I have german characters which "Umlauts" which I would like to get