Re: Japanese words
From: KC Wong (my_at_privacy.net)
Date: 08/05/04
- Previous message: Alex Molochnikov: "Scribe Report Generator - beta testers needed"
- In reply to: Simon Hayes: "Re: Japanese words"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Date: Thu, 5 Aug 2004 13:09:53 +0800
Emilio said:
> > I'm trying to read a varchar(50) field writed in Japanese using this
> > sentence:
> > is = rset.getBinaryStream(num);
> > at that sentence the JDBC driver shows the following error:
> > java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for
> > JDBC]Unsupported data conversion.
Simon said:
> I don't really know, but the most obvious data type for Japanese in MSSQL
> would be nvarchar(50), ie. Unicode. Apart from that, varchar/nvarchar are
> character data, not binary, so perhaps you should be using a different
> method instead of getBinaryStream()?
I have successfully used the MS JDBC driver for SQL server to select/insert
Chinese data from MSSQL server. I used getBinaryStream() for the field.
The problem is probably because of the data type - try nvarchar instead of
varchar, as Simon said.
- Previous message: Alex Molochnikov: "Scribe Report Generator - beta testers needed"
- In reply to: Simon Hayes: "Re: Japanese words"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Relevant Pages
|
