Cannot import Japanese text

[VaibhavJ]

Hi all, Currently I am working on importing data from SQL 2000 database to SQL 2005 database. The original SQL 2000 database contains Japanese as well as English text. For importing data from SQL 2000 to SQL 2005 I have followed following steps. 1. I have created SQL script for generating table structure in SQL 2005. Which I executed and it created table structure in SQL 2005. 2. I have created SQL script for generating stored procedures in SQL 2005. This was also successful. 3. Same way, I have created user defined functions in SQL 2005. 4. But the problem comes while importing data to SQL 2005. For this I have done following things. - Exported the data from SQL 2000 database to an excel sheet.and - Import to SQL 2005 database which is causing problems. :( There is no problem with importing data which is in English to SQL 2005. But as we have to import Japanese text alongwith English, it is causing problems. * * * Error is * * * "The character-string data type of the Unicode form and the character-string data types of the form other than Unicode cannot be converted by the row "Description". So, I guess the problem is related to the importing of combination of UNICODE and Non-Unicode data to SQL 2005. So, please let me know if we can use some other alternatives for importing of Japanese text to SQL 2005. Any suggestion/solution from you on this issue is greatly appreciated. Thanks in advance. Thanks & regards, Vaibhav

[Member 96]

Hmmm..I have no idea if this is at all relevant, but it almost sounds as if you are using a form to do the import? Shouldn't you just be doing something akin to BCP or bulk copy or directly in code without involving a UI part at all?

[VaibhavJ]

Hi John, Thanks for your prompt reply. As per your suggestion I executed bcp command in the command prompt. URL referred : http://www.databasejournal.com/features/mssql/article.php/3391761 First I used following command to export data from source table in SQL 2000 database table to a .bcp file [DatabaseName].dbo.[tablename] out c:\file1.bcp -n -S[servername] -U[username] -P[password] Next I used following command to import data to the target table on SQL 2005 database [DatabaseName].dbo.[tablename] out c:\file1.bcp -n -S[servername] -U[username] -P[password] But it looks to me as if I need to write as many statements to export/import data for as many tables. Anyway, thanks again for your valuable suggestions as it gave me right direction.:) Thanks & regards, Vaibhav