• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar

TeraTech

The ColdFusion Experts: Develop | Secure | Optimize

  • Services
    • Consulting
    • Crash
    • Development
    • Maintenance
    • Modernization
    • Security
  • About Us
  • Testimonials
  • Free Assessment
  • Get in touch!

  • Services
    • Consulting
    • Crash
    • Development
    • Maintenance
    • Modernization
    • Security
  • About Us
  • Testimonials
  • Free Assessment
  • Get in touch!

Simple Unicode Tips

February 16, 2022 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.

…

  • Facebook
  • Twitter
  • LinkedIn

Related Posts

  • Adobe ColdFusion Certification Program
  • Stress shouldn’t rule a ColdFusion developer’s life
  • Log4j New Security Vulnerability and ColdFusion (Critical Zero Day Attack)
  • Cold Depression and ColdFusion
  • How To Find Your Next Job As a ColdFusion Developer
  • Programmer Burnout (Prevent and Deal With it Successfully)
  • ColdFusion Development: Less Coding for Faster Turnaround
  • 4 Ways to Recognize a Good ColdFusion Consultant

Filed Under: ColdFusion Developer

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

Primary Sidebar

Popular podcast episodes

  • Revealing ColdFusion 2021 – Rakshith Naresh
  • CF and Angular – Nolan Erck
  • Migrating legacy CFML – Nolan Erck
  • Adobe API manager – Brian Sappey
  • Improve your CFML code – Kai Koenig

CF Alive Best Practices Checklist

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

Get your checklist

Top articles

  • CF Hosting (independent guide)
  • What is Adobe ColdFusion
  • Is Lucee CFML now better than ACF?
  • Is CF dead?
  • Learn CF (comprehensive list of resources)

Recent Posts

  • 141 Into The Box 2025 ColdFusion conference (all the details) with Daniel Garcia – Transcript
  • 141 Into The Box 2025 ColdFusion conference (all the details) with Daniel Garcia
  • 107 ColdFusion 2021 Revealing Details on How it was Created with Rakshith Naresh
  • The Legacy Continues: ColdFusion Summit East Conference Edition
  • 140 BoxLang modern JVM language that runs CFML code (new CFML engine and much more) with Luis Majano and Brad Wood – Transcript

Categories

  • Adobe ColdFusion 11 and older
  • Adobe ColdFusion 2018
  • Adobe ColdFusion 2020 Beta
  • Adobe ColdFusion 2021
  • Adobe ColdFusion 2023
  • Adobe ColdFusion 2024
  • Adobe ColdFusion 2025
  • Adobe ColdFusion Developer week
  • Adobe ColdFusion Project Stratus
  • Adobe ColdFusion Summit
  • AWS
  • BoxLang
  • CF Alive
  • CF Alive Podcast
  • CF Camp
  • CF Tags
  • CF Vs. Other Languages
  • CFEclipse
  • CFML
  • CFML Open- Source
  • CFUnited
  • ColdBox
  • ColdFusion and other news
  • ColdFusion Community
  • ColdFusion Conference
  • ColdFusion Consulting
  • ColdFusion Developer
  • ColdFusion Development
  • ColdFusion Hosting
  • ColdFusion Maintenance
  • ColdFusion Performance Tuning
  • ColdFusion Projects
  • ColdFusion Roadmap
  • ColdFusion Security
  • ColdFusion Training
  • ColdFusion's AI
  • CommandBox
  • Docker
  • Fixinator
  • Frameworks
  • Fusebox
  • FusionReactor
  • IntoTheBox Conference
  • Java
  • JavaScript
  • JVM
  • Learn CFML
  • Learn ColdFusion
  • Legacy Code
  • Load Testing
  • Lucee
  • Mindmapping
  • MockBox
  • Modernize ColdFusion
  • Ortus Developer Week
  • Ortus Roadshow
  • Server Crash
  • Server Software
  • Server Tuning
  • SQL
  • Survey
  • Survey results
  • TestBox
  • Transcript
  • Webinar
  • Women in Tech

TeraTech

  • About Us
  • Contact

Services

  • Free assessment
  • Consulting
  • Crash
  • Development
  • Maintenance
  • Modernization
  • Security
  • Case Studies

Resources

  • CF Alive Book
  • CF Alive Podcast
    • Podcast Guest Schedule
  • TeraTech Blog
  • CF Alive resources
  • CF e-course
  • CF best practice checklist

Community

  • CF Alive
  • CF Inner Circle
  • CF Facebook Group

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–2025 TeraTech Inc. All rights Reserved. Privacy Policy.