My Problem (Data)

I connect to my Database by using classes111.jar, and I retrieve data from it.

this data some of it is on Arabic language and the rest of it is on English,the data which is in English appears correctly when I stored it in a PDF file but the Arabic Data it is not appear at all.

when I checked what's wrong I found that the Arabic data when I put it in a ResultSet and print it, it appears as question marks!!!!!!

So, what do I have to do?

Am I need a library ? or using some code to encode or something like that?

please,

[559 byte] By [ahd292000a] at [2007-10-3 3:45:47]
# 1
check installed language fonts. question marks/squares/nothing appears when the font is not available.Even if your JRE does not have Arabic fonts, it should use them fine, except for displaying them. If your PDF viewer cannot display them, update it with new fonts and try again
lfschucka at 2007-7-14 21:42:20 > top of Java-index,Core,Core APIs...
# 2
Hello Ifschuck,Thanks for your answer and helpHow can I know that the JRE have an Arabic fonts or not?Can I install the Arabic fonts in JRE or what? because I want to display them in Arabic.
ahd292000a at 2007-7-14 21:42:20 > top of Java-index,Core,Core APIs...
# 3

well... since you cannot display Arabic characters, it's obvious that your JRE does not have them! =P

a simple way to find out which fonts are installed in your JRE is like this:

Locale[] locs = Locale.getAvailableLocales();

String s = "";

for (Locale loc : locs) {

s += loc

+"\n\tName: "+loc.getDisplayName(Locale.US)

+"\n\tLocal name: "+loc.getDisplayName(loc)

+"\n";

}

System.out.println(s);

JFrame frame = new JFrame();

frame.add(new JScrollPane(new JTextArea(s)));

frame.pack();

frame.setVisible(true);

You can indeed install fonts for whatever language you need... but the process is really cumbersome. I once did a quick attempt but gave up, because it's a pain! I was trying to install Japanese/Chinese/Korean characters, because every other is already installed in my JRE by default (including Arabic).

sorry to not give you better tips, but this might take some time and I can't (souldn't ;-) afford it. use google to find some answers... here are some links I collected:

http://java.sun.com/j2se/1.3/docs/guide/intl/addingfonts.html

http://java.sun.com/j2se/1.3/docs/guide/intl/fontprop.html

best of luck!

lfschucka at 2007-7-14 21:42:20 > top of Java-index,Core,Core APIs...
# 4

hello lfschuck ,

I tried your code and it gave me that the JRE that I use it contains Arabic, but the result as I told you before, does not appear Arabic until now.

The result of your code is :

ar

Name: Arabic

Local name: العربية

ar_AE

Name: Arabic (United Arab Emirates)

Local name: العربية (الإمارات)

ar_BH

Name: Arabic (Bahrain)

Local name: العربية (البحرين)

ar_DZ

Name: Arabic (Algeria)

Local name: العربية (الجزائر)

ar_EG

Name: Arabic (Egypt)

Local name: العربية (مصر)

ar_IQ

Name: Arabic (Iraq)

Local name: العربية (العراق)

ar_JO

Name: Arabic (Jordan)

Local name: العربية (الأردن)

ar_KW

Name: Arabic (Kuwait)

Local name: العربية (الكويت)

ar_LB

Name: Arabic (Lebanon)

Local name: العربية (لبنان)

ar_LY

Name: Arabic (Libya)

Local name: العربية (ليبيا)

ar_MA

Name: Arabic (Morocco)

Local name: العربية (المغرب)

ar_OM

Name: Arabic (Oman)

Local name: العربية (سلطنة عمان)

ar_QA

Name: Arabic (Qatar)

Local name: العربية (قطر)

ar_SA

Name: Arabic (Saudi Arabia)

Local name: العربية (السعودية)

ar_SD

Name: Arabic (Sudan)

Local name: العربية (السودان)

ar_SY

Name: Arabic (Syria)

Local name: العربية (سوريا)

ar_TN

Name: Arabic (Tunisia)

Local name: العربية (تونس)

ar_YE

Name: Arabic (Yemen)

Local name: العربية (اليمن)

hi_IN

Name: Hindi (India)

Local name: हिंदी (भारत)

iw

Name: Hebrew

Local name: עברית

iw_IL

Name: Hebrew (Israel)

Local name: עברית (ישראל)

ja

Name: Japanese

Local name: 日本語

ja_JP

Name: Japanese (Japan)

Local name: 日本語 (日本)

ko

Name: Korean

Local name: 한국어

ko_KR

Name: Korean (South Korea)

Local name: 한국어 (대한민국)

th

Name: Thai

Local name: ไทย

th_TH

Name: Thai (Thailand)

Local name: ไทย (ประเทศไทย)

th_TH_TH

Name: Thai (Thailand,TH)

Local name: ไทย (ประเทศไทย,TH)

vi

Name: Vietnamese

Local name: Tiếng Việt

vi_VN

Name: Vietnamese (Vietnam)

Local name: Tiếng Việt (Việt Nam)

zh

Name: Chinese

Local name: 中文

zh_CN

Name: Chinese (China)

Local name: 中文 (中国)

zh_HK

Name: Chinese (Hong Kong)

Local name: 中文 (香港)

zh_TW

Name: Chinese (Taiwan)

Local name: 中文 (台灣)

be

Name: Belarusian

Local name: беларускі

be_BY

Name: Belarusian (Belarus)

Local name: беларускі (Беларусь)

bg

Name: Bulgarian

Local name: български

bg_BG

Name: Bulgarian (Bulgaria)

Local name: български (България)

ca

Name: Catalan

Local name: catal?br>ca_ES

Name: Catalan (Spain)

Local name: catal?(Espanya)

cs

Name: Czech

Local name: če歵ina

cs_CZ

Name: Czech (Czech Republic)

Local name: če歵ina (Česk?republika)

da

Name: Danish

Local name: dansk

da_DK

Name: Danish (Denmark)

Local name: dansk (Danmark)

de

Name: German

Local name: Deutsch

de_AT

Name: German (Austria)

Local name: Deutsch (謘terreich)

de_CH

Name: German (Switzerland)

Local name: Deutsch (Schweiz)

de_DE

Name: German (Germany)

Local name: Deutsch (Deutschland)

de_LU

Name: German (Luxembourg)

Local name: Deutsch (Luxemburg)

el

Name: Greek

Local name: ελληνικά

el_GR

Name: Greek (Greece)

Local name: ελληνικά (Ελλάδα)

en_AU

Name: English (Australia)

Local name: English (Australia)

en_CA

Name: English (Canada)

Local name: English (Canada)

en_GB

Name: English (United Kingdom)

Local name: English (United Kingdom)

en_IE

Name: English (Ireland)

Local name: English (Ireland)

en_IN

Name: English (India)

Local name: English (India)

en_NZ

Name: English (New Zealand)

Local name: English (New Zealand)

en_ZA

Name: English (South Africa)

Local name: English (South Africa)

es

Name: Spanish

Local name: espa駉l

es_AR

Name: Spanish (Argentina)

Local name: espa駉l (Argentina)

es_BO

Name: Spanish (Bolivia)

Local name: espa駉l (Bolivia)

es_CL

Name: Spanish (Chile)

Local name: espa駉l (Chile)

es_CO

Name: Spanish (Colombia)

Local name: espa駉l (Colombia)

es_CR

Name: Spanish (Costa Rica)

Local name: espa駉l (Costa Rica)

es_DO

Name: Spanish (Dominican Republic)

Local name: espa駉l (Rep鷅lica Dominicana)

es_EC

Name: Spanish (Ecuador)

Local name: espa駉l (Ecuador)

es_ES

Name: Spanish (Spain)

Local name: espa駉l (Espa馻)

es_GT

Name: Spanish (Guatemala)

Local name: espa駉l (Guatemala)

es_HN

Name: Spanish (Honduras)

Local name: espa駉l (Honduras)

es_MX

Name: Spanish (Mexico)

Local name: espa駉l (M閤ico)

es_NI

Name: Spanish (Nicaragua)

Local name: espa駉l (Nicaragua)

es_PA

Name: Spanish (Panama)

Local name: espa駉l (Panam?

es_PE

Name: Spanish (Peru)

Local name: espa駉l (Per?

es_PR

Name: Spanish (Puerto Rico)

Local name: espa駉l (Puerto Rico)

es_PY

Name: Spanish (Paraguay)

Local name: espa駉l (Paraguay)

es_SV

Name: Spanish (El Salvador)

Local name: espa駉l (El Salvador)

es_UY

Name: Spanish (Uruguay)

Local name: espa駉l (Uruguay)

es_VE

Name: Spanish (Venezuela)

Local name: espa駉l (Venezuela)

et

Name: Estonian

Local name: Eesti

et_EE

Name: Estonian (Estonia)

Local name: Eesti (Eesti)

fi

Name: Finnish

Local name: suomi

fi_FI

Name: Finnish (Finland)

Local name: suomi (Suomi)

fr

Name: French

Local name: fran鏰is

fr_BE

Name: French (Belgium)

Local name: fran鏰is (Belgique)

fr_CA

Name: French (Canada)

Local name: fran鏰is (Canada)

fr_CH

Name: French (Switzerland)

Local name: fran鏰is (Suisse)

fr_FR

Name: French (France)

Local name: fran鏰is (France)

fr_LU

Name: French (Luxembourg)

Local name: fran鏰is (Luxembourg)

hr

Name: Croatian

Local name: hrvatski

hr_HR

Name: Croatian (Croatia)

Local name: hrvatski (Hrvatska)

hu

Name: Hungarian

Local name: magyar

hu_HU

Name: Hungarian (Hungary)

Local name: magyar (Magyarorsz醙)

is

Name: Icelandic

Local name: 韘lenska

is_IS

Name: Icelandic (Iceland)

Local name: 韘lenska (蛃land)

it

Name: Italian

Local name: italiano

it_CH

Name: Italian (Switzerland)

Local name: italiano (Svizzera)

it_IT

Name: Italian (Italy)

Local name: italiano (Italia)

lt

Name: Lithuanian

Local name: Lietuvių

lt_LT

Name: Lithuanian (Lithuania)

Local name: Lietuvių (Lietuva)

lv

Name: Latvian

Local name: Latvie歶

lv_LV

Name: Latvian (Latvia)

Local name: Latvie歶 (Latvija)

mk

Name: Macedonian

Local name: македонски

mk_MK

Name: Macedonian (Macedonia)

Local name: македонски (Македонија)

nl

Name: Dutch

Local name: Nederlands

nl_BE

Name: Dutch (Belgium)

Local name: Nederlands (Belgi?

nl_NL

Name: Dutch (Netherlands)

Local name: Nederlands (Nederland)

no

Name: Norwegian

Local name: norsk

no_NO

Name: Norwegian (Norway)

Local name: norsk (Norge)

no_NO_NY

Name: Norwegian (Norway,Nynorsk)

Local name: norsk (Norge,nynorsk)

pl

Name: Polish

Local name: polski

pl_PL

Name: Polish (Poland)

Local name: polski (Polska)

pt

Name: Portuguese

Local name: portugu阺

pt_BR

Name: Portuguese (Brazil)

Local name: portugu阺 (Brasil)

pt_PT

Name: Portuguese (Portugal)

Local name: portugu阺 (Portugal)

ro

Name: Romanian

Local name: rom鈔ă

ro_RO

Name: Romanian (Romania)

Local name: rom鈔ă (Rom鈔ia)

ru

Name: Russian

Local name: русский

ru_RU

Name: Russian (Russia)

Local name: русский (Россия)

sk

Name: Slovak

Local name: Slovenčina

sk_SK

Name: Slovak (Slovakia)

Local name: Slovenčina (Slovensk?republika)

sl

Name: Slovenian

Local name: Sloven?#269;ina

sl_SI

Name: Slovenian (Slovenia)

Local name: Sloven?#269;ina (Slovenija)

sq

Name: Albanian

Local name: shqipe

sq_AL

Name: Albanian (Albania)

Local name: shqipe (Shqip雛ia)

sr

Name: Serbian

Local name: Српски

sr_BA

Name: Serbian (Bosnia and Herzegovina)

Local name: Српски (Босна и Херцеговина)

sr_CS

Name: Serbian (Serbia and Montenegro)

Local name: Српски (Србија и Црна Гора)

sv

Name: Swedish

Local name: svenska

sv_SE

Name: Swedish (Sweden)

Local name: svenska (Sverige)

tr

Name: Turkish

Local name: T黵k鏴

tr_TR

Name: Turkish (Turkey)

Local name: T黵k鏴 (T黵kiye)

uk

Name: Ukrainian

Local name: українська

uk_UA

Name: Ukrainian (Ukraine)

Local name: українська (Україна)

en_US

Name: English (United States)

Local name: English (United States)

en

Name: English

Local name: English

so, what's wrong ?

and what should I do?

Note: I found that the Charset is ( windows-1252), and you know that the Charset for Arabic is (windows-1256), so how can I change the Charset, please?

or will you give me and an alternative solution?

Message was edited by:

ahd292000

Message was edited by:

ahd292000

ahd292000a at 2007-7-14 21:42:20 > top of Java-index,Core,Core APIs...