Multi Language Applications in Cold Fusion in Theory

Multi Language Applications in Cold. Fusion in Theory and Practice Oğuz Demirkapı Sr. Application Developer, Niche. Click Media europe. cfunited. com March 12 th- 13 th 2008

About Me � Sr. Application Developer at Niche. Click Media � Coding since ‘ 85, CGI Programming since ’ 94 � Cold. Fusion Developer since ’ 97 � Founder and Manager (prev) of CFUG for Turkey � Interested in Cold. Fusion, Flex, Ajax, Frameworks, i 18 N, L 10 N, g 13 N � Have big interest in epistemology europe. cfunited. com March 12 th- 13 th 2008

What is coming. . . � Preview ◦ Theory ◦ Contents � i 18 N Tips ◦ Cold. Fusion Tips (Server & Code) ◦ Database Tips � Questions & Answers europe. cfunited. com March 12 th- 13 th 2008

Theory � Do we need mutilingualism? ◦ Yes! � Time Zones � Calendars � Cultural Differences europe. cfunited. com March 12 th- 13 th 2008

What is …? � What is i 18 N (Internationalization)? ◦ Application functions in at least two locales � What is L 10 N (Localization)? ◦ Process of applying a locale or language "skin" to an i 18 N application � What is G 11 N (Globalization)? ◦ i 18 N & L 10 N europe. cfunited. com March 12 th- 13 th 2008

Unicode � What is Unicode? � Why do we need to use Unicode? � Cold. Fusion Versions ◦ Cold. Fusion MX ◦ Converting Cold. Fusion 5 or older projects into MX is a headache with Unicode europe. cfunited. com March 12 th- 13 th 2008

Cold. Fusion 5 & MX � Cold. Fusion MX � Converting Cold. Fusion 5 or older projects into MX is a headache with Unicode � Cold. Fusion MX � Cold. Fusion 8 europe. cfunited. com March 12 th- 13 th 2008

Server � � Setting up your environment for multilingual applications: Code organization, database server settings, Cold. Fusion server settings, development tools etc. DEMO europe. cfunited. com March 12 th- 13 th 2008

Code � Code & Code Isolation ◦ Java Resource Bundle ◦ IBM ICU 4 J Library ◦ GNU Get. Text() � Database or File/XML Usage ◦ Not the best but still popular europe. cfunited. com March 12 th- 13 th 2008

DEMO � Sample ◦ ◦ ◦ ◦ Applications Basic Techniques File Handling Mail Usage Fusebox Model-Glue Far. Cry GNU Get. Text() � DEMO europe. cfunited. com March 12 th- 13 th 2008

Cold. Fusion Tips – Server � Use Cold. Fusion MX ◦ If possible Cold. Fusion MX 7. x and up � Use Updated JVM � Setting Correct Locale � Use DSN Settings ◦ MS SQL Server ◦ MS Access with Unicode Support europe. cfunited. com March 12 th- 13 th 2008

Cold. Fusion Tips – IDE � Use Unicode Capable Editor � Dreamweaver Good ◦ Support BOM � Eclipse/CFEclipse Not Bad ◦ No BOM creation ◦ OK for current files with BOM � Homesite/CFStudio Never! ◦ http: //www. adobe. com/go/tn_19059 europe. cfunited. com March 12 th- 13 th 2008

Cold. Fusion Tips – Code � Use Unicode ◦ If possible with BOM support � Cold. Fusion MX Detect BOM ◦ If you have BOM support on your file Cold. Fusion understand your locale and there is no need to use extra tags such as cfprocessingdirective europe. cfunited. com March 12 th- 13 th 2008

Cold. Fusion Tips – Code � Cold. Fusion MX Templates ◦ If there is no BOM <cfprocessingdirective pageencoding=“utf-8"> must be included in every CFM template. ◦ Using in Application. cfm etc. does not help europe. cfunited. com March 12 th- 13 th 2008

Cold. Fusion Tips – Code �Beware of Cold. Fusion Functions & Tags ◦ CFPROCESSINGDIRECTIVE, CFCONTENT, CFFILE, CFHEADER, CFHTTPPARAM, CFMAILPART tags and the SETENCODING, GETENCODING, TOBASE 64, TOSTRING, URLDECODE, and URLENCODEDFORMAT functions etc. �Use encoding in Tags <cfmail to="#user#" from="#me#" subject="Unicode Test" charset="utf-8"> <cfmailpart charset="utf-8" type="plain“>#mymailasplaintext# </cfmailpart> <cfmailpart charset="utf-8" type="html“>#mymailashtml# </cfmailpart> </cfmail> europe. cfunited. com March 12 th- 13 th 2008

Cold. Fusion Tips – Database � Use ◦ ◦ a robust database MS SQL Server My. SQL Server Postgre. SQL Server Oracle � Beware of Unicode Support ◦ My. SQL 4. 1 and up europe. cfunited. com March 12 th- 13 th 2008

Cold. Fusion Tips – Database � Use Right Locale ◦ UTF 8 in My. SQL ◦ Especially important in My. SQL � Beware of Field Types ◦ SQL Server nvarchar, ntext etc. europe. cfunited. com March 12 th- 13 th 2008

Resources �Adobe ü Developer Center http: //www. adobe. com/devnet/coldfusion/localization_globalization. html �Globalizing Cold. Fusion. MX ◦ Paul Hastings ◦ http: //www. sustainablegis. com/blog/cfg 11 n/ europe. cfunited. com March 12 th- 13 th 2008

Questions & Answers ? Oguz. Demirkapi@gmail. com (Unfortunately we do not have Unicode support on e-mail addresses. ) europe. cfunited. com March 12 th- 13 th 2008