Index and DDL object size behavior

zoeeoz · **Joined:** Fri Feb 20, 2004 4:56 pm **Posts:** 14

Hi all,

I have a question regarding the use of index parameter:

If I use following mapping

<property name="XXX"
type="string"
length="30">
<column name="XXX"
index="ID_XXX"/>
</property>

Dedicated table contains :

XXX VARCHAR(255) NULL,

If I use following mapping

<property name="XXX"
type="string"
length="30">
</property>

Dedicated table contains :

XXX VARCHAR(30) NULL,

So, how a column composed of a varchar(30) can be indexed or is it Database related ?

Thanks in advance,
zoeeoz

emmanuel · **Posted:** Fri Apr 02, 2004 1:42 pm

zoeeoz wrote:

So, how a column composed of a varchar(30) can be indexed or is it Database related ?

This is DB related, but why can't a varchar column be indexed ?