Rita Chammas

Greenhorn
+ Follow
since Dec 05, 2012
Merit badge: grant badges
For More
Cows and Likes
Cows
Total received
0
In last 30 days
0
Total given
0
Likes
Total received
0
Received in last 30 days
0
Total given
0
Given in last 30 days
0
Forums and Threads
Scavenger Hunt
expand Ranch Hand Scavenger Hunt
expand Greenhorn Scavenger Hunt

Recent posts by Rita Chammas

Below is a description of our problem in using the JDBC connection to retrieve Arabic data from sql server 2008 r2 database in a powerbuilder 9 application.

Given:
1. powerbuilder 9 application
2. Sql server 2008 r2 database:
a. collation: Arabic_CI_AS
3. Microsoft JDBC driver
Problem:
We have an issue in retrieving/writing Arabic data to the database using JDBC connection inside powerbuilder 9 application.
Arabic Data is committed to the database using an ODBC connection correctly in the powerbuilder application; however we need to use JDBC connection to read the Arabic data but it is displayed as question marks (??? ???).
After research we have tried the below properties to solve the issue which none resolved it:
1. useUnicode=yes;
2. charSet=utf8; charSet=utf-8; charSet=windows1256; charSet=CP1256;
3. CodePageOverride=utf8; CodePageOverride=utf-8; CodePageOverride= windows1256; CodePageOverride= CP1256;
4. characterEncoding=UTF8; characterEncoding =utf-8; characterEncoding = windows1256; characterEncoding = CP1256;

• we can insert/retrieve Arabic data through an ODBC connection succesfully.
• We have queried the data in SQL Server Management Studio: • If the data is inserted using a JDBC connection the query will retrieve ‘??? ???’
• If the data is inserted using an ODBC connection, and retrieved using a JDBC connection it will be ‘??? ???’



It is sure that the font used in PB can display Arabic characters properly. we have tried to read Arabic characters from a string successfully.


Your PROMPT help is much appreciated ASAP.