Solved

How to input chinese characters on Sybase 15 using Coldfusion 8 ?

Posted on 2009-07-15
3
977 Views
Last Modified: 2013-12-24
I'm having problems to input chinese characters on sybase database when using Coldfusion 8 as front-end (using the default connection driver which comes with coldfusion).
The database has charset working well, since i can insert/search/view the characters when using other tools. On Coldfusion, i can view the characters... just can not insert/update chinese chars.
On application.cfm, i've included the script setEncoding for form/url scope to encode as utf-8, included also the tag <cfcontent type="text/html; charset=utf-8">, and on all my pages i've included the tag <cfprocessingdirective pageencoding="utf-8">.
I've searched i think all topics of coldfusion+languages on this site, but i think all of them were related to My SQL database, and not helpfull to me.

Any help on this issue ?
0
Comment
Question by:jackdaniel_china
[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
  • 2
3 Comments
 
LVL 14

Expert Comment

by:shru_0409
ID: 24857631
0
 

Author Comment

by:jackdaniel_china
ID: 24866232
Hi Shru,

I've checked the link, but it didn't help.. I don't get any error on CF neither on Sybase..
I've tried also creating a new datasource with a Sybase jdbc driver and passing the parameters useUnicode=true&characterEncoding=utf-8 on the jdbc url, but didn't work..

Thanks
0
 

Accepted Solution

by:
jackdaniel_china earned 0 total points
ID: 24867771
Hi,

The problem was solved by using the jdbc driver provided by Sybase (jConnect) instead of the one shipped with Coldfusion, and adding  below parameters to the jdbc url:
DISABLE_UNICHAR_SENDING=false&JCONNECT_VERSION=6

Thanks
0

Featured Post

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

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

Most ColdFusion developers get confused between the CFSet, Duplicate, and Structcopy methods of copying a Structure, especially which one to use when. This Article will explain the differences in the approaches with examples; therefore, after readin…
Meet the world's only “Transparent Cloud™” from Superb Internet Corporation. Now, you can experience firsthand a cloud platform that consistently outperforms Amazon Web Services (AWS), IBM’s Softlayer, and Microsoft’s Azure when it comes to CPU and …
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an antispam), the admini…
Attackers love to prey on accounts that have privileges. Reducing privileged accounts and protecting privileged accounts therefore is paramount. Users, groups, and service accounts need to be protected to help protect the entire Active Directory …

732 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