"�",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
M. Martin
> Cc: sqlite mailing list
> Subject: [sqlite] Weird chars inserted
>
> 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.
&g
7;t recognize.
Check http://www.fileformat.info/info/unicode/char/00ed/index.htm
as a reference.
I use Linux (Xubuntu)
regs,
Kev
From: "Ariel M. Martin"
To: " sqlite-users@mailinglists.sqlite.org"
Subject: [sqlite] Weird chars inserted
Message-ID: <835952.64146...@sm
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
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 (the Firefox addin) my strings
look
weird like that. But S
10 matches
Mail list logo
