RE: Encoding problem in migration from CF 5 to CF MX

Sat, 29 Jan 2005 02:35:26 -0800

Thanks for the quick response! The data in the DB was inserted using CF 5. I am not sure how to figure out the encoding. I have attached screenshot from the DB, let me know if you can make out something from that.
 
Thanks again!
Ketan

Daniel Elmore <[EMAIL PROTECTED]> wrote:

The default encoding for CFMX is UTF-8 Unicode, what encoding is the data in the DB stored in?

 

 

Daniel Elmore

 

From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ketan
Sent: Saturday, January 29, 2005 3:59 AM
To: [email protected]
Subject: Encoding problem in migration from CF 5 to CF MX

 

Guys,

 

Recently, we upgraded from CF 5 to CF MX. We are now happy to have MBCS (Multi-Byte Character System) support for our application.

 

But we now came across a very strange problem, whatever data we stored using CF5 in DB (SQL Server 2000) is now not displaying correctly on .cfm pages in MX. All multi-byte characters are displaying corrupt. Following is an example:

 

Japanese string with CF 5 looks like: 'テスト用㝮登'  (img1.gif)

same string with CF MX now looks like 'c

c[1]9c
g(c쳌.g;'  (img2.gif)

 

What has gone wrong here? What changes do I have to do to fix this? Why doesn't CFMX understand the encoding?

 

Any help on this topic will be highly appreciated! Currently, this is the highest priority in my area.

 

Thanks in advance!

Ketan

----------------------------------------------------------------------------------------------

 

 

You are an _expression_ of the almighty. The spirit of God
resides within you and moves through you. Open your heart, speak to that spirit and it will heal and empower you. My God has never failed me.

Do you Yahoo!?
Read only the mail you want - Yahoo! Mail SpamGuard.



 

You are an _expression_ of the almighty. The spirit of God
resides within you and moves through you. Open your heart, speak to that spirit and it will heal and empower you. My God has never failed me.

Do you Yahoo!?
Yahoo! Search presents - Jib Jab's 'Second Term'

<<inline: screen1.gif>>

Reply via email to