japanese characters are showing as junk

Question

User-1474376986 posted

 HI,

I am using asp.net 2.0 and oracle 10g server for my websie development,

it is a multi-lingual application,so we implemented localization from property files,here all japanese characters are showing fine,

but when we enter some japanese text in textbox and inserting into database it's showing as junk.

my database charater set is:WE8ISO8859P1

the same database we are using for another appliation which is there in coldfusion,here every thing is working fine and showing japanese text properly.

i tried all the things which are available in internet but still same issue.please suggest me how i can acheive this functionality.

i am using asp.net 2.0

client to connect DB is system.data.oracleclient

i put debug point in code and saw the japanese text in quickwatch window it is showing properly but after insertion it's showing as junk.

 

Regards

Bharath

 

 

 

Answer 1

User-1363023537 posted

Have you tried using FCKEditor or  Tiny_MCA ?

Answer 2

User-1474376986 posted

Hi,

I went through your links,but i don't want any text editor just a textbox(asp.net) which will accept japanese charaters and display japanese characers.

Regards

Bharath

Answer 3

User665793701 posted

It will be better if you use some Unicode character.

Answer 4

User665793701 posted

Chk out this link

 

http://stanford.edu/dept/itss/docs/oracle/10g/server.101/b12170/ch12.htm

Answer 5

User1349123926 posted

WE8ISO8859P1 doesnt support japanese characters.  You'll need to use a database characterset that does.

Ignore any "but it works when I use _________ tool" results.  Your database has to support the characters you're trying to store, otherwise it's not validly stored and all bets are off.

If you dont want to change the characterset of your database, you could use NVarchar2/NChar/NClob datatype instead; thats what theyre there for.

Hope it helps,
Greg