Dmitry Yemanov dim...@users.sourceforge.net [firebird-support] wrote:
> IIRC, unicode derived case/accent insensitive collations use
> six bytes per character encoding. This gives us 2010 bytes
> which is pretty near the 1/4 page size. Given that some
> overhead should be taken into account, the ke
DYdusnfs> IIRC, unicode derived case/accent insensitive collations use six bytes
DYdusnfs> per character encoding. This gives us 2010 bytes which is pretty near
DYdusnfs> the 1/4 page size. Given that some overhead should be taken into
DYdusnfs> account, the key length may in fact overflow the li
30.09.2014 19:19, Geoff Worboys wrote:
>
> CREATE INDEX MyIndex1 ON MyTable1 (Field1, Field2);
>
> where Field1 is VARCHAR(80)
>Field2 is VARCHAR(255)
>
> both use the database default CHARACTER SET WIN1252 with
> collation WIN1252_NOCASE as defined like this:
>
> CREATE COLLATION WIN1252_U