Re: [Q] Data type for text data?

SeungLak Choi <slchoi@dbserver.kaist.ac.kr>: * I am using IUS and Web DataBlade. * I need data type that can hold text data whose size are at least 8KB. * * I couldn't use CLOB because it has only file I/O functions. I need a * assignment operator which assigns a text entered by the users in web page * to a field. * Also, I couldn't use lvarchar because its size is limited to 2KB. * * What data type should I use to meet conditions above? Use the HTML type that comes with the web datablade. It should work for text up to 32Kb. The disadvantage is that if you want to create a text search index on this column using something like the ETX text search datablade you cant use the HTML type. I had that problem and solved it partially by writing a TextBox java applet that I use instead of the <TEXTAREA> HTML component. That java applet sends the text as a client side upload to the webserver, and then I do a filetoclob() on that uploaded content (insert into a CLOB column) Email me if you would like a copy of that applet. Hope this helps Hrafnkell