TeraTech

The ColdFusion Experts: Develop, Secure, Optimize

  • Services
  • About Us
  • CF Alive
  • Blog
  • Podcast
  • Contact

Free Consultation:
Call 301-424-3903

  • Services
  • About Us
  • CF Alive
  • Blog
  • Podcast
  • Contact

Simple Unicode Tips

December 21, 2006 By Michaela Light Leave a Comment

Here are some simple tips that would be helpful while working with Unicode data.

– While registering Microsoft SQL Server Database, please be sure to check "Enable Unicode for data sources configured for non-Latin characters" setting in ColdFusion DSN settings.

MS SQL Server Un'code setting in CF Admin

– If you are using MS SQL Server, use "nvarchar", "nchar" etc. for text fields.

– If you are using MySQL, use "utf8" as main encoding for tables.


    CREATE TABLE unicode_stuff (
    ...
    ) CHARACTER SET utf8;

– Use "cfqueryparam" in SQL queries.



    SELECT FirstName,
    LastName
    FROM employees
    WHERE LastName =

– Use a Unicode capable editor such as Dreamweaver or Eclipse. Do not use Homesite or CFStudio for projects that we need Unicode support.

Adobe TechNote: Unicode issues in HomeSite/HomeSite+ 5.5

http://www.adobe.com/go/tn_19059

– Save your files in "Unicode" and BOM (Byte Order Mark) enabled. This is possible in any text editor such as Notepad or in Dreamweaver. BOM is important for Unicode text that we have direct as static content in our files.

DW Unicode Page

– Use meta tag to have Unicode support.



– Try to use standard coding such as XHTML.




...

Related Posts

  • What I Do After First Dreamweaver InstallationWhat I Do After First Dreamweaver Installation
  • SQL tricks – creative JOINs with legacy dataSQL tricks – creative JOINs with legacy data
  • SQL Reserved word or not, that is the questionSQL Reserved word or not, that is the question
  • ColdFusion server not so expensiveColdFusion server not so expensive
  • 18 Amazing JQuery tips (that will supercharge Web 2.0 apps)18 Amazing JQuery tips (that will supercharge Web 2.0 apps)
  • Query of Query bugQuery of Query bug
  • Facebook
  • Twitter
  • Google+
  • LinkedIn

Filed Under: ColdFusion, Tips

← Previous Post Scorpio on the Rise!
Next Post → ColdFusion captcha

CF Alive Best Practices Checklist

 

Modern ColdFusion development best practices that reduce stress, inefficiency, project lifecycle costs while simultaneously increasing project velocity and innovation.

Recent Posts

  • Top 10 CF Alive Podcasts of 2018 (Editor’s Choice)
  • State of the CF Union Survey 2019 and how is ColdFusion Even More Alive This Year
  • State of the CF Union 2019 (in depth annual ColdFusion survey)
  • CF India Summit Part Three: All About ColdFusion Scheduled Tasks
  • ColdFusion vs PHP vs Java vs .Net (which is a better friend) with Brian Cain- Transcript

Categories

  • ActionScript
  • Adobe CF Summit East 2018
  • AIR
  • Ajax
  • API
  • Apollo
  • CF Alive Book
  • CF Alive Podcast
  • CF Camp
  • CF Summit India
  • CF Training
  • CFEclipse
  • CFObjective
  • CFSummit
  • CFUnited
  • Classes
  • Client Highlights
  • ColdFusion
  • ColdFusion 2018
  • ColdFusion 9
  • Cool Stuff
  • Culture
  • Development Approach
  • Docker
  • Flex
  • Fusebox
  • FusionReactor
  • Futurology
  • IntoTheBox Conference
  • Java
  • JavaScript
  • Learn ColdFusion
  • Load Testing
  • Lucee
  • Management
  • MAX
  • MDCFUG Lunch
  • Monitoring
  • Muracon
  • NCDevCon
  • New Intern
  • News
  • Ortus Developer Week
  • Ortus Roadshow
  • Productivity
  • Security
  • Server Software
  • Server Tuning
  • Social Media
  • Spiral Web
  • SQL
  • Success Story
  • Survey
  • Technology
  • Tips
  • Transcript
  • Trapeze Development
  • Uncategorized
  • Web 2.0
  • Webinar
  • Webmail
  • Whole Brain Development
  • Women in Tech

Recent Comments

  • Michaela Light on A Comprehensive Guide to Running a Successful CFML Project
  • Michaela Light on Is Lucee CFML now better than Adobe ColdFusion?
  • Michaela Light on Introducing Swansea Jack (Lucee CFML 6 announced)
  • Michaela Light on 082 ColdFusion and the Blockchain Revolution with Mike Brunt
  • Michaela Light on 082 ColdFusion and the Blockchain Revolution with Mike Brunt
  • Home
  • Services
  • About Us
  • CF Alive
    • CF Alive Book
    • CF Alive Inner Circle
    • CF Alive full resources cheatsheet
  • Blog
  • Podcast
    • Podcast Guest schedule
  • Contact
  • Sitemap

The ColdFusion Experts:
Develop, Secure, Optimize

TeraTech Inc
451 Hungerford Drive Suite 119
Rockville, MD 20850

Tel : +1 (301) 424 3903
Fax: +1 (301) 762 8185

Copyright © 1998–2019 TeraTech Inc. All rights Reserved.