On Tue, Oct 7, 2014 at 5:02 AM, Richard Hipp <d...@sqlite.org> wrote:

> On Tue, Oct 7, 2014 at 12:06 AM, J Decker <d3c...@gmail.com> wrote:
>
> > I saw a few things go by about unicode... and understand that it should
> > just work to store the data as characters...
> >
> > I'm getting a unrecognized token... and think this page isn't right...
> > I was playing with greek translation of 'mary had a little lamb'
> >
> > http://www.sqlite.org/tokenreq.html
> >
>
>
> Wait.  Stop right there.  Where did you find that page?  That page is many
> years obsolete and out of date and is not maintained.  The older banner
> across the top should be a clue.
>
> Did you get there via a link?  Can you tell me what the link is so that I
> can delete it?
>
> I did a google search for 'sqlite unicode unrecognized token replace'  was
the first search result.


https://www.google.com/webhp?sourceid=chrome-instant&rlz=1C1ASUM_enUS603US603&ion=1&espv=2&ie=UTF-8#q=sqlite+unicode+unrecognized+token+replace


>
>
> >
> > -----------
> > "MySQL allows identifiers to be quoted using the grave accent character.
> > SQLite supports this for interoperability.
> >
> > H41160: SQLite shall recognize as an ID token any sequence of characters
> > that begins with a grave accent (u0060), is followed by zero or more
> > non-zero characters and/or pairs ofgrave accents (u0060) and terminates
> > with a grave accent (u0022) that is not part of a pair."
> >
> > ----------
> >
> >
> > 20:57:51.729|Editoptions@getoption_v4.c(472):Result of prepare failed?
> > unrecognized token: "'Μαίρη είχε " at char 0[replace into option4_values
> > (`option_id`,`string`,`segment` ) values
> > ('8b377a68-4358-11e4-ace4-3085a9903449','Μαίρη είχε ένα μικρό αρνί',0)]
> in
> > [replace into option4_values (`option_id`,`string`,`segment` ) values
> > ('8b377a68-4358-11e4-ace4-3085a9903449','Μαίρη είχε ένα μικρό αρνί',0)]
> >
> >
> > -----------
> >
> > The actual data isn't as it looks here, as during the unicode to
> character
> > conversion of the select fix the wide characters that don't convert unto
> > utf-8 representations...
> >
> > this is memory of the command.  that is being passed to prepare.....
> >  between the ' ' there is no non zero character that is not a '....
> >
> > 0x00000000029844E8  72 65 70 6c 61 63 65 20 69 6e 74 6f 20 6f 70 74 69 6f
> > 6e 34 5f 76 61 6c 75 65 73 20 28 60 6f 70 74  replace into option4_values
> > (`opt
> > 0x0000000002984509  69 6f 6e 5f 69 64 60 2c 60 73 74 72 69 6e 67 60 2c 60
> > 73 65 67 6d 65 6e 74 60 20 29 20 76 61 6c 75  ion_id`,`string`,`segment`
> )
> > valu
> > 0x000000000298452A  65 73 20 28 27 38 62 33 37 37 61 36 38 2d 34 33 35 38
> > 2d 31 31 65 34 2d 61 63 65 34 2d 33 30 38 35  es
> > ('8b377a68-4358-11e4-ace4-3085
> > 0x000000000298454B  61 39 39 30 33 34 34 39 27 2c 27 e0 8e 9c e0 8e b1 e0
> > 8e af e0 8f 81 e0 8e b7 20 e0 8e b5 e0 8e af  a9903449','àŽœàŽ±àŽ¯à..àŽ·
> > àŽµàŽ¯
> > 0x000000000298456C  e0 8f 87 e0 8e b5 20 e0 8e ad e0 8e bd e0 8e b1 20 e0
> > 8e bc e0 8e b9 e0 8e ba e0 8f 81 e0 8f 8c 20  à..àŽµ àŽ.àŽ.àŽ±
> > àŽ.àŽ.àŽºà..à.Œ
> > 0x000000000298458D  e0 8e b1 e0 8f 81 e0 8e bd e0 8e af 27 2c 30 29 00 fe
> > ca ef be fe ca ef be cd fd fd fd fd ab ab ab
> >  àŽ±à..àŽ.àŽ¯',0).þÊï.þÊï.Íýýýý«««
> > _______________________________________________
> > sqlite-users mailing list
> > sqlite-users@sqlite.org
> > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
> >
>
>
>
> --
> D. Richard Hipp
> d...@sqlite.org
> _______________________________________________
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to