[#CORE-1802] Maximum key size using PXW_CSY collation

Firebird Core

Maximum key size using PXW_CSY collation

Created: 25/Mar/08 07:19 AM Updated: 26/Jan/09 08:26 AM

Return to search

Component/s:

None

Affects Version/s:

2.1 RC2

Fix Version/s:

2.5 Alpha 1, 2.1.1

Time Tracking:

Not Specified

Issue Links:

Relate

This issue is related to:

~~QA-211~~ Test for CORE-1802

Planning Status:

Unspecified

Description

« Hide

In FB2.0 it is possible to create index on
  VARCHAR(499) CHARACTER SET WIN1250 COLLATE PXW_CSY
column, while in FB2.1 the maximum is only 330.
(seems FB2.1 considers that collation as 3-level, while 2.0 as 2-level)

RECREATE TABLE TAB21(
  ID INTEGER,
  A VARCHAR(330) CHARACTER SET WIN1250 COLLATE PXW_CSY,
  CONSTRAINT CU UNIQUE(A) );

RECREATE TABLE TAB20(
  ID INTEGER,
  A VARCHAR(499) CHARACTER SET WIN1250 COLLATE PXW_CSY,
  CONSTRAINT CU UNIQUE(A) );

All

Comments

Work Log

Change History

Version Control

Sort Order:

The cvs commits can not be displayed for repository Firebird at the moment since the log has not yet been parsed. The log will be parsed the next time the VcsService runs. If you have administrators privileges you can hasten the next time the service will run in the service section of the Administration pages.