Hi Mark,

Thank you for the prompt response.

Yes, I am using UTF8 as the character set; I need to ensure that the data supports UNICODE and UTF8 fits best with Delphi 7.

I did not know about the restrictions, based upon character length.

I will keep this in mind for next database.

With many thanks,
Michael

--- In firebird-support@yahoogroups.com, Mark Rotteveel <mark@...> wrote:
>
> 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
>