Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Old Forums
 CLOSED - SQL Server 2005/Yukon
 How to store and retrieve Japanese characters in M

Author  Topic 

niranjan
Starting Member

1 Post

Posted - 2006-10-06 : 08:08:08
Dear All,

I am using JDK 1.5 with MS-SQL 2000(devlopment)/ 2005(deployment) as backend. I am try to store japanese text/charachters in the MS-SQL using jdbc. But whatever the japanese charaters are getting stored in MSSQL as ?????(which I think are corrupted-as read from internet.).
1. My problem is I want to store them exactly in the Japanese language formats(Kanji/or so).
2. In the same way when I am retriving it from database I am getting ???? only. Not the actual Japanese charaters which I have inserted.


P.N.: I am using:
mssqlserver.jar ---DB Driver.. connectivity

Can anyone suggest me the solution for the same?

Thanks in Advance,

Best Regards,

Niranjan
email: bnhsniranjan@gmail.com

Kristen
Test

22859 Posts

Posted - 2006-10-06 : 08:15:15
Presumably you are storing the data in an Nvarchar or Ntext datatype column? (rather than just Varchar or Text datatypes)

Kristen
Go to Top of Page
   

- Advertisement -