Hi folks,
As a basic and limited user of Oracle and databases, I'm wondering what you would suggest as the best workaround for the varchar2 4000 char limit.
Knowing that I will have textual data that needs to be saved that will be more than 4,000 characters, how would you suggest handling that?
The data being stored is used in a Web Authoring Tool which will be later retrieved when rendering web pages. Thus, search engine optimization is a factor, as well as speed.
I dont know much about CLOBs, so I'm wondering if using CLOBs is the best idea - or if using multiple varchar2's and using some kind of identifier to string them together.
Any advice would be greatly appreciated.
Thanks for your time!
Jeff
As a basic and limited user of Oracle and databases, I'm wondering what you would suggest as the best workaround for the varchar2 4000 char limit.
Knowing that I will have textual data that needs to be saved that will be more than 4,000 characters, how would you suggest handling that?
The data being stored is used in a Web Authoring Tool which will be later retrieved when rendering web pages. Thus, search engine optimization is a factor, as well as speed.
I dont know much about CLOBs, so I'm wondering if using CLOBs is the best idea - or if using multiple varchar2's and using some kind of identifier to string them together.
Any advice would be greatly appreciated.
Thanks for your time!
Jeff