Re: [sqlite] C code spanish character insert problem

:56am, Bible Trivia Extreme wrote: > > > Open your spanish.txt file in a hex editor. The letter 'ñ' should be > > > >> encoded as C3 B1. If you see F1 instead, it means your file is in > >> ISO-8859-1 or something similar. > >>

Re: [sqlite] C code spanish character insert problem

Open your spanish.txt file in a hex editor. The letter 'ñ' should be > encoded as C3 B1. If you see F1 instead, it means your file is in > ISO-8859-1 or something similar. > ___ > > Thanks Dan, it seems to be F1. So what do I do exactly? Im assuming

Re: [sqlite] C code spanish character insert problem

On Tue, Sep 29, 2009 at 9:48 PM, Simon Slavin <slav...@hearsay.demon.co.uk>wrote: > > On 30 Sep 2009, at 2:25am, Bible Trivia Extreme wrote: > > > Is there something special I need to do in the C/Sqlite > > code to make this work properly? > > Which SQLite functio

[sqlite] C code spanish character insert problem

Hello- Im trying to figure out why I cannot get spanish characters into my sqlite DB properly. Im using a C program to read a text file that is already translated into spanish. When I look at this file the spanish characters (tilde n, acentos etc) are correct. When I run the C program and open