RE: Charsets when querying db

2003-06-24 Thread Bryan Love
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

Re: Charsets when querying db

2003-06-24 Thread Jochem van Dieten
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):

RE: Charsets when querying db

2003-06-24 Thread Bryan Love
, 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

Re: Charsets when querying db

2003-06-24 Thread Ryan Mitchell
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

Re: Charsets when querying db

2003-06-24 Thread Ryan Mitchell
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

Re: Charsets when querying db

2003-06-24 Thread Jochem van Dieten
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:

Re: Charsets when querying db

2003-06-24 Thread Jochem van Dieten
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

Re: Charsets when querying db

2003-06-24 Thread Ryan Mitchell
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