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