Re: special characters in mysql
thanks guys, still having trouble but have managed to upload content directly to the database (bypassing cms). tiny mce seems to be my problem now as it converts the correct content back to something else then i am back at the start. arrghh. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319514 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: special characters in mysql
Might want to post *that* question to the TinyMCE forums...? http://tinymce.moxiecode.com/punbb/ (I looked through http://wiki.moxiecode.com/index.php/TinyMCE:Index and did not see anything obvious.) On Thu, Feb 19, 2009 at 2:21 AM, Mike Little m...@nzsolutions.co.nz wrote: thanks guys, still having trouble but have managed to upload content directly to the database (bypassing cms). tiny mce seems to be my problem now as it converts the correct content back to something else then i am back at the start. arrghh. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319517 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: special characters in mysql
aha, i see it has done the same on this site. basically the characters have accents on them. mike ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319471 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: special characters in mysql
In MS SQL Server, solution is to use nvarchar instead of varchar and ntext instead of text. Not sure about MySQL... On Wed, Feb 18, 2009 at 6:42 AM, Mike Little m...@nzsolutions.co.nz wrote: aha, i see it has done the same on this site. basically the characters have accents on them. mike ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319472 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: special characters in mysql
from what i can see ntext is not supported in mysql john. i am using mysql 4.1 by the way. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319473 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: special characters in mysql
http://forums.mysql.com/read.php?103,2074,2233#msg-2233 On Wed, Feb 18, 2009 at 6:52 AM, Mike Little m...@nzsolutions.co.nz wrote: from what i can see ntext is not supported in mysql john. i am using mysql 4.1 by the way. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319474 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: special characters in mysql
Since it sounds like you've already got the column set to receive UTF-8, you'll need to ensure that you're also coding the data going into the database and being displayed. Drop this in your application file or at the top of your global index file or wherever: this codes the characters when displayed: cfcontent type=text/html; charset=UTF-8 this codes the data when a form gets submitted: cfset setEncoding(form, UTF-8) In other words, you need to ensure it's going into the DB in the same way it's getting referenced when you try to display it. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319475 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: special characters in mysql
MySQL 4.1 does support unicode, not sure if it uses nvarchar/ntext/etc though. Here is some info on the improvements between 4.0 and 4.1 http://dev.mysql.com/tech-resources/articles/4.1/unicode.html ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319476 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: special characters in mysql
Mike Little wrote: can anyone see what i may be doing wrong? what db driver (ie JDBC or ODBC, should be JDBC driver)? what ver of cf (should be something newer than cf5)? can you post the input code? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319482 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: special characters in mysql
With Mysql 5 and CF 8 I needed to add this connection string to the datasource: jdbc:mysql:// 127.0.0.1:3306/utf8demo?allowMultiQueries=truecharacterEncoding=UTF8characterSetResults=UTF8 Also the charset I used in MySql was: utf8 the colation was: utf8_general_ci; After that I was able to insert all the funny accents, Russian charsets and Asian charsets. Paul. On Wed, Feb 18, 2009 at 9:39 AM, Paul Hastings p...@sustainablegis.comwrote: Mike Little wrote: can anyone see what i may be doing wrong? what db driver (ie JDBC or ODBC, should be JDBC driver)? what ver of cf (should be something newer than cf5)? can you post the input code? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319485 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4