characteristic length

Hello Gurus,

I have a field whose length is 1000 char which has to be extracted from Sql table into BW. Could somebody suggest me a way of doing it. As far as I am concerned Characteristic data type can take only 60 char at the maximum. Pls help.

Thanks

jose