My database is configured with encoding "UTF-8". I have a table with a constraint check for 20 characters on a column. This mostly works, but sometimes has some strange behaviour.
One character in particular has caused a problem. The hex value is "C2AC" - the "NOT SIGN (U+00AC)". Hopefully the character will appear between the quotes "?". When I insert this character into the table, it will only allow ten characters to be input. If I do "select length(name) from myTable;" the result shows that each of the "C2AC" characters is counted as two characters. I noticed that "C2" is a valid ANSI character, as is "AC", so wonder if the length() function is not dealing correctly with the range from 0x80-0xff. sqlite> .version SQLite 3.8.11.1 2015-07-29 20:00:57 cf538e2783e468bbc25e7cb2a9ee64d3e0e80b2f Has anyone else seen this problem, or found a solution? Thanks, Glyn.
