Oracle also has a limit. I am not sure what that limit is, but I have
hit it before.

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?
>
>R.
>
> -----Original Message-----
> From: Leyne, Sean [mailto:sleyne@...]
> Sent: Tuesday, April 08, 2003 1:04 PM
> To: ib-support@yahoogroups.com
> Subject: RE: [ib-support] key size too big for index
>
>
> > I guess I'm not understanding the size of index keys.
> >
> > CREATE TableFoo (
> > id INTEGER,
> > foo VARCHAR(120),
> > bar VARCHAR(120) );
> >
> > CREATE INDEX tableFoo_foo ON TableFoo(foo);
> >
> >
> > This fails telling me that the key size is too big. What
> > exactly is the limit for VARCHAR keys?
>
> What charset are you using for the table/database?
>
> Index Keys are limited to 252 (or is it 242? -- I can't recall
>exactly)
> *bytes*, which in the case of a three-byte charset would result
>in
> VARCHAR(120) needing 362 bytes!
>
>
> Sean
>
>
>Yahoo! Groups Sponsor
>ADVERTISEMENT
>
><http://rd.yahoo.com/M=246920.2960106.4328965.1728375/D=egroupweb/S=1705
>115386:HM/A=1513703/R=0/*http://www.gotomypc.com/u/tr/yh/cpm/grp/300_06F
>/g22lp?Target=mm/g22lp.tmpl>
>
><http://us.adserver.yahoo.com/l?M=246920.2960106.4328965.1728375/D=egrou
>pmail/S=:HM/A=1513703/rand=122547486>
>
> 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]
>
>
>
>To unsubscribe from this group, send an email to:
>ib-support-unsubscribe@egroups.com
>
>
>
>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>
>
>

--
Thomas Miller
Delphi Client/Server Certified Developer
BSS Accounting & Distribution Software
BSS Enterprise Accounting FrameWork

http://www.bss-software.com
http://sourceforge.net/projects/dbexpressplus