Kbase 21817: Progress Databases, ColdFusion Servers and Codepages
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
20/02/2002 |
|
SUMMARY:
Pulling data from a Progress database into a ColdFusion server using custom tags might result in garbled output in a browser.
EXPLANATION:
ColdFusion combines a tag-based language, visual tools, and a web application server for developing web-based applications. It offers integration with databases through ODBC and Java class tags. There is no native Progress interface.
ColdFusion does not do any code conversion. It accepts the data as given to it and outputs the data as it receives it. However, if the data is submitted to ColdFusion via custom tags (Java class files installed and registered on ColdFusion servers), these tags might carry encoding of standard code pages (ISO8859-1 or UTF8).
If the encoding in the custom tags is not compatible, that is the same as the code page used in the Progress database, then the final output will be incorrect in the browser (garbled or otherwise not legible). The Java custom tag will convert the data received from the Progress database to the code page encoded within the tag.
If the Progress database was using ISO8859-1, for example, and the Java custom tags were designed to use UTF-8, then the data from the database would be converted to UTF-8, passed to the ColdFusion server and output to a browser, which defaults to ISO8859-1, resulting in garbled output.
SOLUTION:
The solution is to download a tag, from Macromedia's Exchange under the custom tags section, that will convert ISO8859-1 to UTF-8 and UTF-8 to ISO8859-1 again. The tag is CF-CharsetConvert, and is a free download.