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