How to Store and retrieve unicode data into/from MSSql Server
1 posts in topic
Flat View  Flat View
Older Post First |   Reply to Topic
TOPIC ACTIONS:
 

Posted By:   Srinivas_Alla
Posted On:   Wednesday, March 21, 2001 11:47 AM

Using get/SetUnicodeStream methods the data sent through JDBC is converted to ??? if there's any unicode character such as alpha,Beta etc. The datatypes used were nchar,nvarchar. If any single character is inserted using nchar function the data is converted to unicode in sqlquery analyzer, But using jdbc a unicode character taken from textpane could not be inserted into database. Is there anyway to insert unicode data to sqlserver using jdbc?

Report | Quote This | Send private message | Reply | Print

Re: How to Store and retrieve unicode data into/from MSSql Server

Posted By:   Andrei_Melejik  
Posted On:   Friday, October 19, 2001 07:16 AM

Yes, use the following:
);
INSERT INTO tbl
(clName)
VALUES (N'foo')

Taje into account 'N' before 'foo'.
Report | Quote This | Send private message | Reply | Print
About | Sitemap | Contact