Hi,

> i am using firebird 1.5.2
> i have a problem about index creating
> my field is domain base
>
> my domain is
> CREATE DOMAIN "STR100" AS VARCHAR(100) CHARACTER SET WIN1254 COLLATE

PXW_TURK;

>
> i used this domain on a field
> i must create an index on this field
>
> CREATE INDEX INDEX1 ON TABLE (STR100FIELD);
>
> i get this error message
> "key size is too big for index INDEX1"
>
> i think the problem is about turkish collation and character set
>
> how can i solve this problem

By making the field smaller. Or using Firebird 2 with the new index
structure.
But Firebird 2 isn't ready for production environments yet.


With regards,

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Server
Upscene Productions
http://www.upscene.com
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com