data migration problem

[Former Member]

hi.

i'm trying to migrate data from xi to a sql database.

the data includes hebrew font values.

the sql databse collation is latin and can not be changed.

when the data is migrated to the sql db, the hebrew values are inserted as gibrish (question marks).

i guess this is a unicode problem.

is there a way to overcome the problem?

[Former Member]

Hi ron

have a look in these links may be helpful for u

http://www.sapdb.org/7.4/htmhelp/db/74d038d35e11d5994400508b6b8b11/content.htm

http://help.sap.com/saphelp_nw2004s/helpdata/en/62/3f2cadb35311d5993800508b6b8b11/content.htm

http://en.wikipedia.org/wiki/Unicode

ABAP and Unicode :

http://help.sap.com/saphelp_nw2004s/helpdata/en/62/3f2cadb35311d5993800508b6b8b11/frameset.htm

Different encoding techniques with unicode :

http://help.sap.com/saphelp_nw2004s/helpdata/en/f2/31c79f828bed47906b882f2af35e3e/frameset.htm

Check this THread, this guy saying he has 'Non-Unicode XI System', how is it possible

See this..

http://help.sap.com/saphelp_nw2004s/helpdata/en/47/eaae42edc6b211e10000000a155106/content.htm

>>>If i have Scenario

R/3 (Non-Unicode) -> XI (Unicode) -> R/3 (Non-Unicode)

What are things we need take into consideration?

Check this thread..

http://www.sapdb.org/7.4/htmhelp/db/74d038d35e11d5994400508b6b8b11/content.htm

http://help.sap.com/saphelp_nw2004s/helpdata/en/62/3f2cadb35311d5993800508b6b8b11/content.htm

Thanks!!

[Former Member]

I think that the problem is in the sql db collation.

are you sure that the latin collation can support the Hebrew characters?

try to create another database with one of these collations (136, 137 or 138) and use this db with your interface.

if it works, the problem is the db collation.

Regards

[Former Member]

Hi ron,

Do you see the hebrew font well in sxmb_moni? or it is also gibrish?

[Former Member]

in sxmb_moni i see hebrew fonts very well.

also when i run sql statement in sql query analyzer and insert hebrew fonts it is ok.