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?
>
> -----------
> "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
