"�",ED,65533,blob
194580,kev5,6B657635,"í",C3AD,237,blob
194581,kev6,6B657636,"aíb",61C3AD62,97,text
194582,kev7,6B657637,c,6300ED64,99,text
194583,kev8,6B657638,"",00ED,,blob
sqlite>
regs,
Kev
Date: Mon, 19 Dec 2016 11:12:59 +0800
From: Rowan Worth
To
On 20 December 2016 at 08:06, Kevin Youren wrote:
> The experiments were conducted by cut-and-paste of the í character from
> the email, hence UTF8,
"Hence UTF8" is presumptuous. There are many encodings the website could be
using to communicate í. The browser may (or may not) convert to UTF8
i
On 19 December 2016 at 08:24, Kevin wrote:
> Hi Martin,
>
> I had a go using a terminal session, with default encoding UTF-8.
>
> Try using the hex( ) and unicode( ) functions to check what is actually
> stored in the sqlite table.
>
> I put a couple of rows at the end of an existing simple table
Inquiring minds want to know how a selection of 5 values resulted in a result
list of 6 values ...
> -Original Message-
> From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org]
> On Behalf Of Kevin
> Sent: Sunday, 18 December, 2016 17:25
> To: Ariel M. Martin
> Cc: sqli
Igor,
On 12/18/2016 7:17 AM, Jean-Christophe Deschamps wrote:
Since your DB is UTF-16LE encoded, you shouldn't convert your strings to
UTF8.
int nRet= sqlite3_exec(m_hDB, szSQL, NULL, 0, &pErrMsg);
alone should work fine.
No it should not. The encoding of the database is irrelevant here
On 12/18/2016 7:17 AM, Jean-Christophe Deschamps wrote:
Since your DB is UTF-16LE encoded, you shouldn't convert your strings to
UTF8.
int nRet= sqlite3_exec(m_hDB, szSQL, NULL, 0, &pErrMsg);
alone should work fine.
No it should not. The encoding of the database is irrelevant here:
sqlite3_e
On 12/17/2016 8:38 PM, Ariel M. Martin wrote:
Note: szSQL is the wchar-string my app uses
char szAux[2048];
ZeroMemory(szAux, 2048);
WideCharToMultiByte(CP_ACP, WC_COMPOSITECHECK, szSQL, wcslen(szSQL),
szAux, 2048, NULL, 0);
Replace CP_ACP with CP_UTF8.
--
Igor Tandetn
Ariel,
At 02:38 18/12/2016, you wrote:
Hi people. I need some help Iâm lost here.
Iâm writing an application using SQLite and whenever I insert
Spanish characters
I get this kind of strings:
Mart�n (where it should read âMartÃnâ)
Ok, so if I open my database with SQLiteManager (th
8 matches
Mail list logo
