December 1, 2009 at 6:20 am
Hi,
We have some database in MS Access with data in Unicode (in Kannada language) data in multiple columns. With Access, these columns are readable easily. But when I port this database to MS SQL (either 2000 or 2005), these columns can not be read. Characters are shown as boxes. The data type for these columns is nvarchar only. What may be the problem here?How to enable the SQL server (either 2000 or 2005) to support Unicode data?
December 1, 2009 at 6:51 am
How did you port the data to SQL server?
when inserting unicode data into SQL server you need to use a leading national 'N' on the query.
December 2, 2009 at 2:55 am
Hi steveb,
Am using DTS service from SQL Server to port data from Access to SQL.
December 2, 2009 at 3:12 am
Since this is the SQL 2005 forum,
can I assume that you are using SQL 2005 and SSIS rather than DTS?
December 2, 2009 at 4:09 am
Yes, am using SQL Serer Import and Export Wizard to port data.
December 2, 2009 at 4:38 am
Sorry i think i was pointing you in the wrong direction
It seems like the problem is that Sql server does not support the Kannada characters by default.
What service pack are you running?
I am not able to get it working here, but I think the problem will have to do with the characters supported by SQL server, If you have SP3 and you are able to select Indic_General_90_CI_AS as the collation that should include the correct characters.
December 2, 2009 at 5:07 am
It appears the problem is not with the collation, though this is important to have for the correct sorting and comparisions of the data.
The problem would be with the language settings in windows.
To display Kannada and other 'complex' languages you will need to;
-Go into control panel
-Select Regional and Language Options
-Click on the Languages tab
-Tick 'Install files for complex script and rigt-to-left languages (including thai)
Click OK and this will install the files from disk.
Restart the computer
and after this you will be able to display Kannada characters (and all other Indian Characters) instead of little boxes.
December 2, 2009 at 6:51 am
Thank you steveb, your last message has solved the problem. After enabling my system for supplemental languages, I can read the data from SQL server.
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply