TeraTech

The ColdFusion Experts: Develop | Secure | Optimize

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

  • Services
  • About
  • 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

  • 054 How to implement Adobe's API Manager (with Swagger, ColdFusion, and API's) with Brian Sappey054 How to implement Adobe's API Manager (with Swagger, ColdFusion, and API's) with Brian Sappey
  • Adobe Apollo Alpha PublicAdobe Apollo Alpha Public
  • 103 Cool Lucee CFML (GigaBytes file parsing and more) with Gert Franz103 Cool Lucee CFML (GigaBytes file parsing and more) with Gert Franz
  • 079 Help Your ColdFusion Team Find Flow (7 keys to PM success) with Christine Ballisty079 Help Your ColdFusion Team Find Flow (7 keys to PM success) with Christine Ballisty
  • 094 Adobe ColdFusion Specialist Certification (new at CF Summit), with Elishia Dvorak094 Adobe ColdFusion Specialist Certification (new at CF Summit), with Elishia Dvorak
  • Everything CF Summit 2018: Unlocking the Power of APIs w/ Adobe API ManagerEverything CF Summit 2018: Unlocking the Power of APIs w/ Adobe API Manager
  • Facebook
  • Twitter
  • 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

  • 4 Reasons Why Your ColdFusion Web Apps Are Suffering (And How To Avoid It)
  • Google Down – An Unprecedented Event (Save Your Data Fast!)
  • 107 ColdFusion 2021 Revealing Details on How it was Created with Rakshith Naresh
  • Into The Box LatAm 2020 Virtual Conference – Free to Register!
  • Slow ColdFusion Applications May Ruin Your Business (3 Steps to Prevent It)

Categories

  • ActionScript
  • Adobe CF Summit
  • Adobe CF Summit East
  • Adobe CF Summit East 2018
  • Adobe ColdFusion 11
  • Adobe ColdFusion 2020 Beta
  • Adobe ColdFusion 2021
  • Adobe ColdFusion Project Stratus
  • Adobe ColdFusion Security
  • AIR
  • Ajax
  • AngularJS
  • Announcement
  • API
  • Apollo
  • Auto Security Lockdown
  • AWS
  • C#
  • Certification
  • CF Alive
  • CF Alive Book
  • CF Alive Podcast
  • CF Camp
  • CF Developer week
  • CF Maintenance
  • CF Summit India
  • CF Tags
  • CF Training
  • CF Vs. Other Languages
  • CFEclipse
  • CFML
  • CFML Open- Source
  • CFObjective
  • cfquery
  • CFSummit
  • CFUnited
  • China Chopper
  • CIO
  • Classes
  • Client Highlights
  • ColdBox
  • ColdFusion
  • ColdFusion 2018
  • ColdFusion 2020
  • ColdFusion 2021
  • ColdFusion 9
  • ColdFusion community
  • ColdFusion Conference
  • ColdFusion Consulting
  • ColdFusion Developer
  • ColdFusion Development
  • ColdFusion Hosting
  • ColdFusion Security
  • ColdFusion Webinar
  • CommandBox
  • Conference
  • Cool Stuff
  • Culture
  • Cybercrime
  • Database
  • Development Approach
  • DevOps
  • Docker
  • Fixinator
  • Flex
  • Frameworks
  • Fusebox
  • FusionReactor
  • Futurology
  • Garbage Collector
  • Google Down
  • Into The Box Latam
  • IntoTheBox Conference
  • Java
  • JavaScript
  • JVM
  • Learn ColdFusion
  • Legacy Code
  • Load Testing
  • Lucee
  • Management
  • MAX
  • MDCFUG Lunch
  • Microsoft Azure
  • Mindmapping
  • MockBox
  • Modernize ColdFusion
  • Monitoring
  • Muracon
  • NCDevCon
  • New Intern
  • News
  • Node.js
  • Open- Source
  • ORM
  • Ortus Developer Week
  • Ortus Roadshow
  • Performance
  • Performance Tuning
  • PHP
  • Productivity
  • Programming Languages
  • Project planning
  • Query of Queries
  • Roadmap
  • Scalability
  • Security
  • Server Software
  • Server Tuning
  • Social Media
  • Spiral Web
  • SQL
  • Success Story
  • Survey
  • Technology
  • TestBox
  • Tips
  • Transcript
  • Trapeze Development
  • Uncategorized
  • Web 2.0
  • Web Application
  • Web Server
  • Webinar
  • Webmail
  • What is ColdFusion?
  • Whole Brain Development
  • Women in Tech
  • Work From Home

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

Follow us on Facebook Follow us on LinkedIn Follow us on Twitter Follow us on Pinterest Follow us on YouTube

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