| Subject | Fields with collation=PXW_SLOV consume 3 bytes per char? |
|---|---|
| Author | aleksander_oven |
| Post date | 2003-10-14T11:30:57Z |
Hi,
I have some VARCHAR(100) fields in my database (Firebird 1.5 RC6) with
charset=WIN1250 and collation=PXW_SLO.
FB doesn't allow me to index such fields, because the field size seems
to be too big, although i believe indexing is supposed to be allowed
for field sizes up to 200 bytes. At least that's what I was told.
After a little experimenting I roughly determined that PXW_SLOV
consumes about 3 times more space than plain WIN1250 collation.
Can someone please explain to me why this is so?
Kind regards,
Aleksander Oven
I have some VARCHAR(100) fields in my database (Firebird 1.5 RC6) with
charset=WIN1250 and collation=PXW_SLO.
FB doesn't allow me to index such fields, because the field size seems
to be too big, although i believe indexing is supposed to be allowed
for field sizes up to 200 bytes. At least that's what I was told.
After a little experimenting I roughly determined that PXW_SLOV
consumes about 3 times more space than plain WIN1250 collation.
Can someone please explain to me why this is so?
Kind regards,
Aleksander Oven