Hi Russ, There are some levels of Unicode support. The one that you mentioned is just a part of it if you have MS SQL Server.
Then: - Activate "Enable High ASCII characters and Unicode for data sources configured for non-Latin characters" in CF DSN settings. - Use CFQueryParam in every query. OR - Use Ns before the query parameters. Here is the technote http://www.adobe.com/go/tn_18331 If you have MySQL: - Use MySQL 4.1.x or newer. - Use utf8 for all settings. - Update your MySQL scripts which has already latin1 such as BlogCFC MySQL script. - Use a Unicode compatible MySQL editor when you need to edit the DB directly. Here is one of my tutorials which explains some more details: http://howtoforge.com/coldfusion7_mysql4.1_connection The CF/HTML templates: - Use Unicode in page encoding. - Use BOM support if you can. If you have BOM support, you do not need to use any extra tag etc. to have support in CF. - If there is no BOM chance use <cfprocessingdirective pageEncoding="utf-8"> in evet single CFM template. Application.cfm etc. usage does not help. - Use meta tags in your HTML. <meta http-equiv="Content-Type" content="text/html; charset=utf-8"> - Do not use Homesite/CFStudio for any unicode page. Check technote http://www.adobe.com/go/tn_19059 These are some must have stuff for basic Unicode support. Of course there are some detailed techniques to organize application in a structure in order to have i18N support and it needs some more extra topics. :) I had a class at CFUnited as "Multi Lingual(i18N) ColdFusion Applications in Theory and Practice" but there was not enough interest. May be next year ... Sincerely, OÄuz Demirkapı Sr. Developer | TeraTech http://www.teratech.com Russ wrote: > Isn't it just a matter of converting the db tables to the nvarchar instead of > varchar? > > Russ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:284270 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
