Configuring Cold Fusion and MySQL

Listed in this document will be a collection of problems I encountered while working with both Cold Fusion and MySQL, and some of the work arounds/solutions I have come across to resolve these problems.

• When planning to store and display large amounts of data in a text field, you have to be aware of a setting in the Cold Fusion Administrator. By default the Long Text Buffer Size is limited to 65,000 characters. As a result should you have more than 65,000 characters to display the excess will be chopped. This problem can be fixed by either increasing the Long Text Buffer Size (better for performance, but still has an impact) or by enabling Long Text Retrieval Settings (can have an impact on performance). These settings can be reached by editing the datasource properties.