Re: VARCHAR2 and writing more than 4000 chars to db

Some databases do not support direct insets or updates if a single comumn is more than 2000-4000 chars. You should use blobs or some kind of server specific code to handle this type of data (I asume it would be impossible so switch to another database where large text colums are allowed ?) - Frank >Hello everyone, > >I am using VARCHAR2. The user enters the text into an html form textbox which I would like to >then add to the database. Unfortunately, I think this means that I cannot add text more than 4000 >characters long. I have a feeling I should be using blobs or such like, but I haven't used them >before. Has anyone else experienced this problem? Have you got any tips? I use Oracle 8. > >Thanks, > >Simon. >