Re: Retrieving foreign characters from DB
To Paul Hastings (and other that may help), I found out that my problem is related to the fact that I use MySQL. When I use MS-Access as the backend everthing seems to work fine. I made a simple insert-form and took care of the encoding in the head of the page. The data gets correctly inserted when submitting the form with MX (as far as I can trust my query tool) but it's not getting display properly when outputting it to screen with MX...? Now is this an CFMX-issue or an MySQL-thing?? Hope you or someone else from the list can point me to a solution. TIA Patric PS Hi CF-Talkers, PS does anyone of know how to retrieve and properly display foreign characters (in this case PS german ones) from an existing MySQL-Datasource with CFMX. My app PS worked with CF5 but now it renders some glyphs where those extended PS characters should appear. The characters are correctly shown in the DB PS when the data is retrieved with any other query-tool. PS Btw the CFMX_Server is the english release, PS not the international. PS Hope my question is understandable PS Patric -- Patric Stumpe mailto:[EMAIL PROTECTED] __ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Retrieving foreign characters from DB
I found out that my problem is related to the fact that I use MySQL. When I use MS-Access as the backend everthing seems to work sorry, been at another site all day. i kind of thought that might be the case--mysql isn't particularly suited to i18n apps, doesn't do unicode, etc. though the driver mm uses (mm.mysql) claims to handle double byte data. i guess have a look at what options for character encoding that driver has to offer. Now is this an CFMX-issue or an MySQL-thing?? since i can work plenty fine with just about any language w/cfmx sql server i will take a stab at blaming mysql... __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Retrieving foreign characters from DB
Hi Paul, could you kindly point me to a direction where can I dig into the options for the mm-mysql-driver? And thanks for repeatingly answering all those questions regarding internationalization even on the mm-forums :) Patric I found out that my problem is related to the fact that I use MySQL. When I use MS-Access as the backend everthing seems to work PH sorry, been at another site all day. PH i kind of thought that might be the case--mysql isn't particularly suited to PH i18n apps, doesn't do unicode, etc. though the driver mm uses (mm.mysql) claims PH to handle double byte data. i guess have a look at what options for character PH encoding that driver has to offer. Now is this an CFMX-issue or an MySQL-thing?? PH since i can work plenty fine with just about any language w/cfmx sql server i PH will take a stab at blaming mysql... PH __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Retrieving foreign characters from DB
could you kindly point me to a direction where can I dig into the options for the mm-mysql-driver? maybe try here: http://sourceforge.net/projects/mmmysql __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Retrieving foreign characters from DB
Thanks a lot Paul. If I find something usefull I'll share my thoughts... Patric could you kindly point me to a direction where can I dig into the options for the mm-mysql-driver? PH maybe try here: http://sourceforge.net/projects/mmmysql PH __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Retrieving foreign characters from DB
Thanks a lot Paul. If I find something usefull I'll share my thoughts... googled a few more: http://www.caucho.com/projects/jdbc-mysql/index.xtp http://www.firstsql.com/java/mysql/ well if you can wait, i've heard (but really no nothing about mysql) that the next version (4.x??) will be unicode compliant. __ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Retrieving foreign characters from DB
Well I read that too. But I think they mentioned it for release 4.1. I just installed the actual devel.-release 4.0.1 alpha. Don't know how long to last. Now I'm trying to get the actual released 2.0.14 MM.MySQL-JDBC-Driver installed into CFMX... Hmm we'll see Patric Thanks a lot Paul. If I find something usefull I'll share my thoughts... PH googled a few more: PH http://www.caucho.com/projects/jdbc-mysql/index.xtp PH http://www.firstsql.com/java/mysql/ PH well if you can wait, i've heard (but really no nothing about mysql) that the PH next version (4.x??) will be unicode compliant. PH __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Retrieving foreign characters from DB
Well folks, I think I got it. MySQL displays german Umlaute! If anyone wants to know reply to the list 'cause i'll take hurry writing the facts... Patric PS Well I read that too. But I think they mentioned it for release 4.1. I PS just installed the actual devel.-release 4.0.1 alpha. Don't know how PS long to last. Now I'm trying to get the actual released 2.0.14 PS MM.MySQL-JDBC-Driver installed into CFMX... Hmm we'll see PS Patric Thanks a lot Paul. If I find something usefull I'll share my thoughts... PH googled a few more: PH http://www.caucho.com/projects/jdbc-mysql/index.xtp PH http://www.firstsql.com/java/mysql/ PH well if you can wait, i've heard (but really no nothing about mysql) that the PH next version (4.x??) will be unicode compliant. PH PS __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Retrieving foreign characters from DB
Hi CF-Talkers, does anyone of know how to retrieve and properly display foreign characters (in this case german ones) from an existing MySQL-Datasource with CFMX. My app worked with CF5 but now it renders some glyphs where those extended characters should appear. The characters are correctly shown in the DB when the data is retrieved with any other query-tool. Btw the CFMX_Server is the english release, not the international. Hope my question is understandable Patric -- Patric Stumpe mailto:[EMAIL PROTECTED] __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Retrieving foreign characters from DB
CFMX cannot read (properly) locales saved with CF5. Paul Hastings who has extended CF localization experience has confirmed with MM this behavior. It looks there is problem with the new database drivers. in any case you should put the following in your Application.cfm file cfcontent type=text/html; charset=your char set cfset setEncoding(URL, your char set) cfset setEncoding(FORM, your char set) Marius Milosav www.scorpiosoft.com It's not about technology, it's about people. Virtual Company (VICO) Application Demo www.scorpiosoft.com/vicodemo/login.cfm - Original Message - From: Patric Stumpe [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, July 01, 2002 11:37 AM Subject: Retrieving foreign characters from DB Hi CF-Talkers, does anyone of know how to retrieve and properly display foreign characters (in this case german ones) from an existing MySQL-Datasource with CFMX. My app worked with CF5 but now it renders some glyphs where those extended characters should appear. The characters are correctly shown in the DB when the data is retrieved with any other query-tool. Btw the CFMX_Server is the english release, not the international. Hope my question is understandable Patric -- Patric Stumpe mailto:[EMAIL PROTECTED] __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Retrieving foreign characters from DB
CFMX cannot read (properly) locales saved with CF5. no, only utf-8 encoded stuff saved via cf5. laurent i (mainly laurent's ideas) are working on a fix for that. my thai saved as varchar--note not N varchar--works plenty fine. in any case you should put the following in your Application.cfm file cfcontent type=text/html; charset=your char set cfset setEncoding(URL, your char set) cfset setEncoding(FORM, your char set) yes these and cfprocessingdirective (in each template) form the big three for i18n work. --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.372 / Virus Database: 207 - Release Date: 20/6/2545 __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Retrieving foreign characters from DB
Well Marius and Paul, would I get the characters to be displayed properly with these modifications to the application.cfm?? Patric CFMX cannot read (properly) locales saved with CF5. no, only utf-8 encoded stuff saved via cf5. laurent i (mainly laurent's ideas) are working on a fix for that. my thai saved as varchar--note not N varchar--works plenty fine. in any case you should put the following in your Application.cfm file cfcontent type=text/html; charset=your char set cfset setEncoding(URL, your char set) cfset setEncoding(FORM, your char set) yes these and cfprocessingdirective (in each template) form the big three for i18n work. --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.372 / Virus Database: 207 - Release Date: 20/6/2545 __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists