RE: Charsets when querying db
What version of MySQL are you using? Try switching to 4.1 if you aren't using it... http://www.mysql.com/doc/en/Charset-Unicode.html +---+ Bryan Love Database Analyst Macromedia Certified Professional Internet Application Developer TeleCommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis Let's Roll - Todd Beamer, Flight 93 -Original Message- From: Ryan Mitchell [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 24, 2003 1:45 PM To: CF-Talk Subject: Charsets when querying db Hello Im having some trouble with querying my db (Mysql on mx), and im getting รบ replaced by funny characters and all sorts like that. I have a feeling its to do with the character sets the db is returning, and the charset on the page... I tried to change the page charset, but no difference, is there any way of forcing the db to return a charset... Either that or its a problem with cfmx... :) Ryan ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Charsets when querying db
Bryan Love wrote: What version of MySQL are you using? Try switching to 4.1 if you aren't using it... You are recommending people to switch to an alpha release? It might be a better idea to try the following in the connectionstring first (presuming the database charset is iso-8859-1): useUnicode=truecharacterEncoding=iso-8859-1 Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Charsets when querying db
My mistake, I was reading up on the differences in unicode handling between 4.0 and 4.1 and I had 4.1 on my mind. Jochem is correct, you would not want to use 4.1. Good lookin' out, Jochem! +---+ Bryan Love Database Analyst Macromedia Certified Professional Internet Application Developer TeleCommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis Let's Roll - Todd Beamer, Flight 93 -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 24, 2003 2:16 PM To: CF-Talk Subject: Re: Charsets when querying db Bryan Love wrote: What version of MySQL are you using? Try switching to 4.1 if you aren't using it... You are recommending people to switch to an alpha release? It might be a better idea to try the following in the connectionstring first (presuming the database charset is iso-8859-1): useUnicode=truecharacterEncoding=iso-8859-1 Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Charsets when querying db
Where do you add that connection string? In the cfadmin or within the query? On 24/6/03 22:16, Jochem van Dieten [EMAIL PROTECTED] wrote: Bryan Love wrote: What version of MySQL are you using? Try switching to 4.1 if you aren't using it... You are recommending people to switch to an alpha release? It might be a better idea to try the following in the connectionstring first (presuming the database charset is iso-8859-1): useUnicode=truecharacterEncoding=iso-8859-1 Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Charsets when querying db
Ok I added it in the cfadmin... Seems to be a bit hit and miss, it does the trick for querying db's, but inserts and stuff seem to be inserting funny chars... My pages have the meta http-equiv=Content-Type content=text/html; charset=iso-8859-1 And cfprocessingdirective pageencoding=iso-8859-1 Lines in them... Is there anything else I should be putting in?? On 24/6/03 22:16, Jochem van Dieten [EMAIL PROTECTED] wrote: Bryan Love wrote: What version of MySQL are you using? Try switching to 4.1 if you aren't using it... You are recommending people to switch to an alpha release? It might be a better idea to try the following in the connectionstring first (presuming the database charset is iso-8859-1): useUnicode=truecharacterEncoding=iso-8859-1 Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Charsets when querying db
Ryan Mitchell wrote: Where do you add that connection string? In the cfadmin or within the query? Admin, under advanced. Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Charsets when querying db
Ryan Mitchell wrote: Seems to be a bit hit and miss, it does the trick for querying db's, but inserts and stuff seem to be inserting funny chars... My pages have the meta http-equiv=Content-Type content=text/html; charset=iso-8859-1 That is not sufficient, it is overruled by the HTTP header which defaults to UTF-8 in CF MX. And cfprocessingdirective pageencoding=iso-8859-1 setEncoding() and cfcontent: http://www.macromedia.com/support/coldfusion/internationalization/internationalization_cfmx/ Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Charsets when querying db
Thanks jochem... As ever!! On 24/6/03 23:52, Jochem van Dieten [EMAIL PROTECTED] wrote: Ryan Mitchell wrote: Seems to be a bit hit and miss, it does the trick for querying db's, but inserts and stuff seem to be inserting funny chars... My pages have the meta http-equiv=Content-Type content=text/html; charset=iso-8859-1 That is not sufficient, it is overruled by the HTTP header which defaults to UTF-8 in CF MX. And cfprocessingdirective pageencoding=iso-8859-1 setEncoding() and cfcontent: http://www.macromedia.com/support/coldfusion/internationalization/internationa lization_cfmx/ Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Host with the leader in ColdFusion hosting. Voted #1 ColdFusion host by CF Developers. Offering shared and dedicated hosting options. www.cfxhosting.com/default.cfm?redirect=10481 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
