?
Solved

Migration Problem: International Characters

Posted on 2003-12-05
3
Medium Priority
?
190 Views
Last Modified: 2013-12-24
Hi,

The situation:
I have a form in a ColdFusion page (note that it's a FORM and NOT a CFFORM).
The user fills out a text box and submits the result to another ColdFusion page.

The Problem:
I used to be running my pages against ColdFusion server Version 4.X and everything was fine. I migrated to a ColdFusion MX server. Now when the form data arrives to the second page (the action page) all the international characters are garbled up. For example "é" becomes "@". I see this using <CFDUMP var=form.textboxName> from the action page.

Obviously the problem is in the international language configuration of the ColdFusion server (since the client PC did not change / Yes I am positive that nothing changed on the client...no new patches...no new browser config...nothing). Did anyone have this problem?
I can't figure out where to change the settings for language under the ColdFusion Administrator.

I got some users comming to use this app in about 2 hours so I rated this high. But even if I can't fix it for today I am still going to need a solution eventualy!

I welcome any and all suggestions.

Thanks
0
Comment
Question by:visorneo
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 9

Accepted Solution

by:
shooksm earned 2000 total points
ID: 9884454
You might try using the ToBase64, ToBinary and ToString functions to manipulate the encoding used by Cold Fusion:

ToBase64 - http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/funca108.htm
ToBinary - http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/funca109.htm
ToString - http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/funca110.htm

The ToString function will let you choose the encoding method as long as it is binary data you are trying to convert.  So in your code you would store ToBinary(ToBase64(FORM.textboxname)) into the database and then use ToString(Query.textboxname, "utf-8") or whatever encoding you actually need.
0

Featured Post

Why Off-Site Backups Are The Only Way To Go

You are probably backing up your data—but how and where? Ransomware is on the rise and there are variants that specifically target backups. Read on to discover why off-site is the way to go.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Originally, this post was published on Monitis Blog, you can check it here . It goes without saying that technology has transformed society and the very nature of how we live, work, and communicate in ways that would’ve been incomprehensible 5 ye…
When it comes to security, close monitoring is a must. According to WhiteHat Security annual report, a substantial number of all web applications are vulnerable always. Monitis offers a new product - fully-featured Website security monitoring and pr…
The purpose of this video is to demonstrate how to manually back up a WordPress Database. This will be demonstrated using a Windows 8 PC. The Host used will be IPage.com Log into your Hosting account. IPage will be used for demonstration : Locat…
The purpose of this video is to demonstrate how to prevent comment spam on a WordPress Website. This will be demonstrated using a Windows 8 PC. Plugin Akismet will be used. Go to your WordPress login page. This will look like the following: myw…
Suggested Courses
Course of the Month13 days, 10 hours left to enroll

801 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question