Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Unable to see chinese characters after data was download from AS400 to SQL2005 Expand / Collapse
Author
Message
Posted Tuesday, January 6, 2009 12:44 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, January 26, 2010 1:29 AM
Points: 1, Visits: 21
Hi all,

We tried to download data from AS400, using SSIS into Database SQL2005/ DTS into database SQL 2000.

In Query Analyzer or Enterprise Manager, we are unable to see data display in chinese characters.

All the columns are set to nchar or nvarchar data types.


If we retrieve the data directly thru ODBC using EXCEL, we are able to see the chinese characters display correctly.

Can I know how to fix the above issue?;)



Post #630352
Posted Friday, November 8, 2013 9:48 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, August 27, 2014 10:46 PM
Points: 17, Visits: 237
Did you find a resolution to the issue?
Post #1512737
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse