Urgent: Bulgarian character set problem

[shibint]

Hai all ,

I have a problem while inserting data to oracle,  when we using Bulgarian  or Greece

characters. We have ti insert all countries PIN/ZIP into a  Option table .

But when we run sql script with special characters like МП Летище Бургас ( Bulgarian )

INSERT INTO

OPTION(LANGUAGE,VERSION,TYPE,module,CODE,description,bemerkung,description2,descrip

tion3) VALUES('DE','SCPRLD','122','ALL','BG001002','МП Летище  Бургас','','','ext');

or    Β΄ ΘΕΣΣΑΛΟΝΙΚΗΣ ( Griechenland - greece  )

INSERT INTO

beoatlas2.OPTION(LANGUAGE,VERSION,TYPE,module,CODE,description,bemerkung,description2,descrip

tion3) VALUES('DE','SCPRLD','122','ALL','GR002002',N'Β΄  ΘΕΣΣΑΛΟΝΙΚΗΣ','','','ext');

it returns as ?????? marks .

I am also tried to insert using java and plssql developer . I saved this file in unicode character set format .

And tried to insert line by line

bufferedFileReader = new BufferedReader(new InputStreamReader(new FileInputStream("MSSQL.sql"), "unnicode"));

then also it displaying as ???????

Oracle data base character set is WE8ISO8859P1

Any sujections are appreciated . Please replay your idieas.

Thanks & Regards
Shibin Thomas

[e-mail],[e-mail]

[shibint]

File is

[wolfgangknauf]

Hi,

you never wrote whether your simple test apps worked or not ;-).

I would assume that there is a configuration "error". Configuring an Oracle is a bit of science...

Best regards

Wolfgang

[shibint]

I tried to insert throrgh plssqldeveloper .

Also i tried through java. reading the file content line by line and used jdbc statement to insert table .

after that also getting  ?????

Any idea ?? how i can insert correctly ???

Thanks

SHIBIN

[wolfgangknauf]

Hi,

please tell me: did you check that your simple test apps worked? Did you try to read the data from your database?

If it works: is the test client running on the same machine as JBoss? Compare the JDBC parameters of test client and JBoss data source.

If the test app does not work: then this is a matter of oracle related forums ;-)

Best regards

Wolfgang