When the contents of an LOB column are exported to the clipboard, a maximum of 1048576 bytes are transferred. If there is more data than this in the results, it will be ignored.
You can export all the contents of an LOB column that exceeds 1048576 bytes to a file.