> -----Original Message----- > From: Namor Taror [mailto:[EMAIL PROTECTED]] > Sent: Saturday, December 15, 2001 9:40 AM > To: Orion-Interest > Subject: SapDB > > > How can I store a variable size string in sapdb. varchar has > a limit of 8000 > which is a limit of all varchars in the raw of the table. SapDb > documentation says that varchar(n) defines a variable length > but it doesn't > seem to work. I am getting exception when i use it while > creating a table. > What gives? We found this ugly limitation this week. We tried to store an xml document that was larger then 8k and got the exception "Not yet implemented". The solution we have implemented is to divide the xml documents in about 7k chunks and add them to another table. When they are needed later we have en entitiy bean that puts them together in the corrrect order. Pretty much the same thing as packets are handled in tcp/ip.
/Thomas Thomas Sundberg MatchProvider Sergels Torg 14 111 57 Stockholm Tel: 08 - 555 16 308 Fax: 08 - 555 16 301 Mobil: 070 - 421 03 88 http://www.matchprovider.com
