[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

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

Posted on 2009-07-15
3
Medium Priority
?
1,003 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

Enroll in October's Free Course of the Month

Do you work with and analyze data? Enroll in October's Course of the Month for 7+ hours of SQL training, allowing you to quickly and efficiently store or retrieve data. It's free for Premium Members, Team Accounts, and Qualified Experts!

Question has a verified solution.

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

This is a guide to setting up a new WHM/cPanel Server to be used for web hosting accounts. It is intended for web hosting company administrators and dedicated server owners. For under $99 per month (considering normal rate of Big Data Cetnters like …
Lease-to-own eliminates the expenditure of hardware replacement and allows you to pay off the server over time. Usually, this is much cheaper than leasing servers. Think of lease-to-own as credit without interest.
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
In a question here at Experts Exchange (https://www.experts-exchange.com/questions/29062564/Adobe-acrobat-reader-DC.html), a member asked how to create a signature in Adobe Acrobat Reader DC (the free Reader product, not the paid, full Acrobat produ…
Suggested Courses

656 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