Java Forum

Ask Question   UnAnswered
Home » Forum » Java       RSS Feeds

Problem with jdbc and farsi database?

  Asked By: Diane    Date: Jun 20    Category: Java    Views: 1118

I have a problem with Unicode in My Application . I want to read
characters from SQL Server Database via a servlet and then represent
them ,
but I can't . Can any one help me ?
Language of letters in my database is Persian ( Farsi ) . I heared
that there is not this problem in Oracle , But Why SQL Server has
this problem ?



2 Answers Found

Answer #1    Answered By: Jana Franklin     Answered On: Jun 20

First of all check to see whether you specified your field types as nvarchar,ntext,nchar. This is necessary for storing data in unicode.

The other thing that you should consider is a property in connection string, In Microsoft JDBC driver it is

It may be different in other JDBC drivers.

Answer #2    Answered By: Clay Cook     Answered On: Jun 20

In ColdFusion MX, there's an option to enabble unicode  support over your
connection to SQL Server. I think you have to search for an alternate
option in your derives. ColdFusion is a java based language  and use jdbc

Didn't find what you were looking for? Find more on Problem with jdbc and farsi database? Or get search suggestion and latest updates.