Fabio, It's is funny you wrote this message because I'm currently having problems with this.
I thought the solution might be to recompile the driver with the max length higher than the 65000 characters. Is this not going to make any difference? -- Jillian -----Original Message----- From: Fabio Serra [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 23, 2002 9:32 AM To: CF-Linux Subject: CFMX + PostgreSQL I'm trying CFMX with PostgreSQL. Good News: 1) The query limit problem is over!! Yuppie. Now, you can insert how much text you want in text fields Bad News: 1) Special chars (eg: \) are not properly ecaped. The query I posted so many times continues to fails.:-(( (eg: String to insert via <input>: this is a test \' hello world) 2) Now, the worst ! I can't work with accented characters like �����. From CFAM in JDBC URL I wrote: jdbc:postgresql://localhost/my_db?charSet=ISO8859_1 and in Application.cfm: <cfprocessingdirective pageencoding="ISO8859_1"> <CFSCRIPT> setEncoding("FORM", "ISO8859_1"); setEncoding("URL", "ISO8859_1"); </CFSCRIPT> I can retrive data correctly form PG but when I try to insert data via form (request method POST) all accented characters are transformed. Changing the carSet in UTF-8 doesn't resolve the problem. I think this time is not a driver issue, but a cfmx problem because using the driver directly from Java doesn't produce the error. I hope to solve this problem ASAP otherwise I have to stay with CF 5. Bye. -------------------------------------------------- FABIO SERRA - faser(at)faser.net PGP available -------------------------------------------------- ______________________________________________________________________ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm ------------------------------------------------------------------------------ Archives: http://www.mail-archive.com/cf-linux%40houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_linux or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
