On 2/17/16, Glyn Jones <glynj at bsquare.com> wrote: > 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. >
What does "select hex(name) FROM myTable" show? -- D. Richard Hipp drh at sqlite.org
