HI
I try to insert some chinese character using xml
into oracle database but it become junk.
I call a batch file it call some jar files and classes file and xslt
my database is in UTF-8 AND I can insert chinese character uisng
sqlplus no problem , i can view also
rds
Message was edited by:
repos
Hi,
I have never tried Chinese characters myself, but I used to have exactly the same problem when reading Thai character (TIS-620) from XML file and insert into database.
I solved my problem by revising XML header to specify correct encoding
EX: I changed from <?xml version="1.0" encoding="ISO-8859-1"?> to <encoding="TIS-620">.
Another solution I used earlier is to convert character encoding myself using
new String(byte[] bytes, String charsetName)
Hope this helps
:)
hi my code is like this
<?xml version="1.0" encoding="ISO-8859-1"?> to <encoding="UTF-8">.
It inserted but it shows ? like this
my class file , xslt all pointing UTF-8
anybody know how to solve this problem
rds
1) Make sure that your xml document is encoded in UTF-8. That doesn't just mean setting the <?xml encoding="UTF-8">, although you should do that also. It means making sure that your xml editor saves the file with the utf-8 encoding.
2) Make sure that you're transmitting/storing/retrieving the data in the db using UTF-8. I'm no db guy, so I can't really help with that part.
3) Make sure that when you display the file after getting it back from the db that you're using UTF-8. What are you using to view the xml after you get it from the db?
As long as you use the correct encoding at every step of the process, then you'll have no problems.
> hi my code is like this
>
> <?xml version="1.0" encoding="ISO-8859-1"?> to
> <encoding="UTF-8">.
>
> It inserted but it shows ? like this
>
> my class file , xslt all pointing UTF-8
>
> anybody know how to solve this problem
>
It is difficult to say what the problem is because you don't say what you are using to view the result and you don't say what is writing the xml.
If you write the xml using an iso-8859-x encoding then just telling the xml parser that it is UTF-8 will not make the xml parser magically reconstruct the characters damaged in the generation.
If your viewer does not have glyphs for the Chinese characters then it won't be able to display them even if they were not damaged during the generation process.
hi
my xml headre look like this
<?xml version="1.0" encoding="UTF-8"?>
MY Oracle db also multibye character db
client send me thedata with chinese & english mixed data in xml format
my batch file call the jar file and class file and xslt to insert the
data into the database
once it inserted the data looks like question mark
if i insert some chinese character through sqlplus it went through
fine and i am able to see it in sqlplus
i suspect this dbmap.class file screwed up the chinese character data
i have no idea where to go and trouble shoot
the mchine whic i run this batch file i set the regional language chinese
and system environment also i set to simplified chinese
try to convert the characters to a hexstring consisting of series of f's
and numerics.
i have only dbmap.class file , i will ask my developer about
dbmap.java
rds
a.k
> any update pls
> rds
You should tell your boss to fire you. You are not competent enough.
You never answerd several of the questions put to you earlier in this thread. You just blab on and on and further demonstrate that you have no clue what you are doing.
So unless you want to try and answer the questions that at least sabre150 put to you please go away. Because there is no point continuing to whine, beg and plead here when we have no clue what the problem might be since you won't share any relevent information with us.
HI
Cotton Dont bulshit any have talk in the forum , I think you are not professional , better you you go and do other jobs , i dont want to
comment in this forum , because this is forum for professional not like
you
