> 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.
You could increase the page size to 8K, thus enlarging the max index key size. Although I wonder if your primary key contains any semantic, which can change over time, thus a bad design decision. The only purpose of a PK should be to uniquely identify a record and reference a record in a FK relationship. Regards, Thomas > I will keep this in mind for next database. > > With many thanks, > Michael > > --- In [email protected], 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 >> > > > > > ------------------------------------ > > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ > > Visit http://www.firebirdsql.org and click the Resources item > on the main (top) menu. Try Knowledgebase and FAQ links ! > > Also search the knowledgebases at http://www.ibphoenix.com > > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ > Yahoo! Groups Links > > >
