Solved

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

Posted on 2009-07-15
3
979 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

Free NetCrunch network monitor licenses!

Only on Experts-Exchange: Sign-up for a free-trial and we'll send you your permanent license!

Here is what you get: 30 Nodes | Unlimited Sensors | No Time Restrictions | Absolutely FREE!

Act now. This offer ends July 14, 2017.

Question has a verified solution.

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

In our day to day coding, how many times have we come across a necessity to check whether a URL is a broken link or not? For those of you that answered countless and are using ColdFusion like myself, then this article is for you.  It will show yo…
Introduction This article explores the design of a cache system that can improve the performance of a web site or web application.  The assumption is that the web site has many more “read” operations than “write” operations (this is commonly the ca…
If you're a developer or IT admin, you’re probably tasked with managing multiple websites, servers, applications, and levels of security on a daily basis. While this can be extremely time consuming, it can also be frustrating when systems aren't wor…
Michael from AdRem Software explains how to view the most utilized and worst performing nodes in your network, by accessing the Top Charts view in NetCrunch network monitor (https://www.adremsoft.com/). Top Charts is a view in which you can set seve…

729 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