Re: [sqlite] SQLite converts all unicode characters into ANSI

Best regards, ZikO From: Tim Streater-3 [via SQLite] [mailto:ml-node+s1065341n65615...@n5.nabble.com] Sent: 19 November 2012 18:35 To: ZikO Subject: Re: SQLite converts all unicode characters into ANSI On 19 Nov 2012 at 01:57, ZikO <[hidden email]> wrote: > The script l

Re: [sqlite] SQLite converts all unicode characters into ANSI

Hi, I am afraid I have done it again but I had no idea I was sending mails with ads. I found your mailing list on this website http://sqlite.1065341.n5.nabble.com/SQLite-converts-all-unicode-characters-into-ANSI-td65589.html and I thought it was a part of this mailing lists. The ads showed

Re: [sqlite] SQLite converts all unicode characters into ANSI

From: Igor Tandetnik [via SQLite] [mailto:ml-node+s1065341n65606...@n5.nabble.com] Sent: 19 November 2012 14:07 To: ZikO Subject: Re: SQLite converts all unicode characters into ANSI ZikO <[hidden email]> wrote: > I then used the conding UTF-8 without BOM and the command was

Re: [sqlite] SQLite converts all unicode characters into ANSI

To: ZikO Subject: Re: SQLite converts all unicode characters into ANSI On 19 Nov 2012, at 1:57am, ZikO <[hidden email]> wrote: > The script was written in Notepad++ > that controls which charset coding is used but I also double checked it in > Notepad and it indicated UTF

Re: [sqlite] SQLite converts all unicode characters into ANSI

From: Clemens Ladisch [via SQLite] [mailto:ml-node+s1065341n65607...@n5.nabble.com] Sent: 19 November 2012 14:20 To: ZikO Subject: Re: SQLite converts all unicode characters into ANSI ZikO wrote: > INSERT INTO imiona (data,imie1,imie2,imie3) VALUES > ('01/01/2012','M

Re: [sqlite] SQLite converts all unicode characters into ANSI

nks for your assistance with that :) -- View this message in context: http://sqlite.1065341.n5.nabble.com/SQLite-converts-all-unicode-characters-into-ANSI-tp65589p65609.html Sent from the SQLite mailing list archive at Nabble.com. ___ sqlite-users ma

Re: [sqlite] SQLite converts all unicode characters into ANSI

> -Original Message- > From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users- > boun...@sqlite.org] On Behalf Of ZikO > Sent: maandag 19 november 2012 02:57 > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] SQLite converts all unicode characters into ANSI &g

Re: [sqlite] SQLite converts all unicode characters into ANSI

On 19 Nov 2012 at 01:57, ZikO wrote: > The script looks like this: > CREATE TABLE IF NOT EXISTS imiona ( > id INTEGER PRIMARY KEY, > data TEXT, > imie1 TEXT, > imie2 TEXT, > imie3 TEXT); > > INSERT INTO imiona (data,imie1,imie2,imie3) VALUES >

Re: [sqlite] SQLite converts all unicode characters into ANSI

On 19 Nov 2012, at 1:57am, ZikO wrote: > The script was written in Notepad++ > that controls which charset coding is used but I also double checked it in > Notepad and it indicated UTF-8; it can also be confirmed by reading the > script text file in Hex editor that shows BOM at the

Re: [sqlite] SQLite converts all unicode characters into ANSI

ZikO wrote: > INSERT INTO imiona (data,imie1,imie2,imie3) VALUES > ('01/01/2012','Masława','Mieczysława','Mieszka'), > > As you can see, it contains accents. The script was written in Notepad++ > that controls which charset coding is used but I also double checked it in > Notepad and it indicated

Re: [sqlite] SQLite converts all unicode characters into ANSI

ZikO wrote: > I then used the conding UTF-8 without BOM and the command was accepted but > unfortunately I get the strange result: > sqlite> select * from imiona; > 1 01/01/2012 MasławaMieczysława Mieszka This looks like correct UTF-8, it's

Re: [sqlite] SQLite converts all unicode characters into ANSI

On Sun, Nov 18, 2012 at 8:57 PM, ZikO wrote: > Hello, > thanks for your answers. > > I downloaded both precompiled binaries and shell for windows from > www.sqlite.org. > > The script looks like this: > CREATE TABLE IF NOT EXISTS imiona ( > id INTEGER PRIMARY KEY, >

Re: [sqlite] SQLite converts all unicode characters into ANSI

aviour. -- View this message in context: http://sqlite.1065341.n5.nabble.com/SQLite-converts-all-unicode-characters-into-ANSI-tp65589p65602.html Sent from the SQLite mailing list archive at Nabble.com. ___ sqlite-users mailing list sqlite-users@sqlite.org htt

Re: [sqlite] SQLite converts all unicode characters into ANSI

> I have a slight problem with sqlite and its text encoding. I read from > documents that sqlite handles UTF-8 by using a command PRAGMA encoding = > "UTF-8"; etc. SQLite assumes UTF-8 unless you specify some other format, such as UTF16 (UTF-16le), UTF16le, or UTF16be Is your text an SBCS file

Re: [sqlite] SQLite converts all unicode characters into ANSI

ZikO wrote: > I have a slight problem with sqlite and its text encoding. I read from > documents that sqlite handles UTF-8 by using a command PRAGMA encoding = > "UTF-8"; etc. My database is to store Polish text. The database is going to > be used with Qt later

Re: [sqlite] SQLite converts all unicode characters into ANSI

On Sat, Nov 17, 2012 at 3:29 PM, ZikO wrote: > I have a slight problem with sqlite and its text encoding. I read from > documents that sqlite handles UTF-8 by using a command PRAGMA encoding = > "UTF-8"; etc. My database is to store Polish text. The database is going to > be used

Re: [sqlite] SQLite converts all unicode characters into ANSI

On 17 Nov 2012, at 1:29pm, ZikO wrote: > I have a slight problem with sqlite and its text encoding. I read from > documents that sqlite handles UTF-8 by using a command PRAGMA encoding = > "UTF-8"; etc. My database is to store Polish text. The database is going to > be used with Qt

Re: [sqlite] SQLite converts all unicode characters into ANSI

ANSI characters? > > Can someone please help me? The application will be international and not > only will I need Polish characters but Spanish etc. > > Thanks > > > > > -- > View this message in context: > http://sqlite.1065341.n5.nabble.com/SQLite-converts-all

[sqlite] SQLite converts all unicode characters into ANSI

nly with ANSI characters? Can someone please help me? The application will be international and not only will I need Polish characters but Spanish etc. Thanks -- View this message in context: http://sqlite.1065341.n5.nabble.com/SQLite-converts-all-unicode-characters-into-ANSI-tp65589.html Sent fr