Or even just supporting a UTF16 encoding should increase performance and
give you 1/3 more room for index key sizes.

R.



-----Original Message-----
From: Daniel Rail [mailto:daniel@...]
Sent: Tuesday, April 08, 2003 1:34 PM
To: ib-support@yahoogroups.com
Subject: Re: [ib-support] key size too big for index


Hi,

At April 8, 2003, 17:17, Robert DiFalco wrote:

> Wow, that's pretty restrictive. Well, our application has to

run in

> multiple locales so we use UNICODE. Oddly enough, it seems

like it uses

> a UTF8 encoding and there is no option for a 2 byte UNICODE

encoding. Is

> this the case with other databases like DB2 and Oracle, that

keys need

> to be less than 252 bytes?

You're not the only one in this predicament, I'm in the same
scenario
too. And, for the moment I can survive without using indices on
those
fields. But I have to admit, it would be nice and would increase
performance in some cases.

Having said that. I know that there are plans to increase the
index
size limit in Firebird 2.0. The reason why it hasn't happened
yet, is
because it requires a major ODS change, and major ODS changes
are
planned for FB 2.0.

--
Best regards,
Daniel Rail
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.filopto.com)



Yahoo! Groups Sponsor

<http://us.ard.yahoo.com/M=249982.3083889.4452939.1728375/D=egroupweb/S=
1705115386:HM/A=1524963/R=0/*http://hits.411web.com/cgi-bin/autoredir?ca
mp=556&llineid=3083889&prop=egroupweb&pos=HM>

<http://us.adserver.yahoo.com/l?M=249982.3083889.4452939.1728375/D=egrou
pmail/S=:HM/A=1524963/rand=173187524>

To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com



Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service <http://docs.yahoo.com/info/terms/> .




[Non-text portions of this message have been removed]