On 20-3-2012 16:26, mpp12310 wrote:

> Hi,
>
> When I try to create a table with the Primary Key field being VARCHAR of length 255, and run Compile, I get an error with:
>
> SQL Code = -607
> IBError Number: 335544351
>
> I checked my Database page size and it is 4096 (default).
>
> I am running FB Server 2.1.4.18393 on WinXP SP3.
>
> I am using SQL Manager Lite for Interbase/Firebird and I am using FlameRobin 0.9.3.2188; the error happens on both GUI managers.
>
> Does anyone else get this error and how did you resolve it?

Are you using UTF-8 as a character set? Indices on (VAR)CHAR fields work
only for limited lenghts:
http://www.firebirdsql.org/file/documentation/reference_manuals/reference_material/html/langrefupd25-ddl-index.html#langrefupd25-tbl-max-indexable-strlen

For a page size of 4096 it is 253 characters if you use UTF8.

Mark
--
Mark Rotteveel