How to Make CLOB Save Spaces
If you run an Oracle database, it is probably divided into Character Large Objects (CLOBs). These store data in chunks of up to 4 GB in size, making them useful for large amounts of text data. If you are storing text, you probably want it formatted a certain way. Because CLOBs run text through basic HTML filters, though, any extra spaces you have will disappear. To make CLOB save spaces, you need to use the HTML code for a space. This allows you to have more than one space between letters or numbers.
Other People Are Reading
Instructions
-
-
1
Open your CLOB data in a text editor such as Notepad.
-
2
Replace any extra spaces with the following five-character code:
 
Note that you can put several of these in a row. For instance, “   ” would create three spaces. Note you only need to do this when you have more than one space you want to save. Standard spacing, between words for instance, will save automatically. -
-
3
Save the file. When you access the CLOB later, the spaces will remain.
-
1
