Solved

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

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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

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…
When it comes to showing a 404 error page to your visitors, you do not want that generic page to show, and you especially do not want your hosting provider’s ad error page to show either. In this article, I will show you how to enable the custom 40…
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…

777 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