Characters coding problem: DOM, charset, BSTR and Oracle DB
-
I'd like to store some data from an XML file to an Oracle Database but there is a problem with several czech characters that are not stored (interpreted, shown?) properly in the database. The way: XML file (UTF-8 charset, czech characters put into document by using XMLSpy) --> MS-VS6, SP5 C++ program (MSXML 4, import raw_interfaces_only) --> DOM(load method, firstChild->get_text(BSTR)) --> BSTR variable --> wchar_t* --> SQLExecDirectW --> connection string including switch to enable forcing SQLWCHARs --> Oracle DB (using Oracle Driver 9.2., CZECH_CZECH REPUBLIC.EE8ISO8859P2 in registry, all Homes) --> displayed in Toad (Arial, Central European). Some characters are replaced by similar ones, some of them can't be recognized. Please, help!
-
I'd like to store some data from an XML file to an Oracle Database but there is a problem with several czech characters that are not stored (interpreted, shown?) properly in the database. The way: XML file (UTF-8 charset, czech characters put into document by using XMLSpy) --> MS-VS6, SP5 C++ program (MSXML 4, import raw_interfaces_only) --> DOM(load method, firstChild->get_text(BSTR)) --> BSTR variable --> wchar_t* --> SQLExecDirectW --> connection string including switch to enable forcing SQLWCHARs --> Oracle DB (using Oracle Driver 9.2., CZECH_CZECH REPUBLIC.EE8ISO8859P2 in registry, all Homes) --> displayed in Toad (Arial, Central European). Some characters are replaced by similar ones, some of them can't be recognized. Please, help!