Copying table with Japanese characters replaces with question marks
Hi I'm using the Transfer SQL Server Objects Task to copy a table from a database with collation = Japanese_CI_AS (on SQL Server 2000) to a table also with collation = Japanese_CI_AS (on SQL Server 2008 R2). In the destination table all Japanese characters are shown as '?'. What am I doing wrong? DropObjectsFirst = true. CopySchema = true (it's a non-dbo schema). I've experimented with UseCollation (true/false) and even IncludeExtendedProperties(true/false). Any ideas will be appreciated. - Hynne
July 12th, 2012 6:39am

what is the data type of your destination column ???? try to change the column to nvarchar, OR ntext. -- Let us TRY this | My Blog :: http://quest4gen.blogspot.com/
Free Windows Admin Tool Kit Click here and download it now
July 12th, 2012 7:10am

What is the code page of the machine running the SSIS package? Dan Guzman, SQL Server MVP, http://weblogs.sqlteam.com/dang/
July 12th, 2012 8:15am

I've only tested it on my developer machine which I believe uses codepage 850 (according to chcp in a command prompt). I'm not sure this is also what SSIS uses. I'm afraid I'm off on vacation, so I won't be able to do any follow-up to this thread for a while. - Hynne
Free Windows Admin Tool Kit Click here and download it now
July 13th, 2012 6:53am

I've only tested it on my developer machine which I believe uses codepage 850 (according to chcp in a command prompt). I'm not sure this is also what SSIS uses. I suspect the code page in question is the Windows code page associated with the default system locale (http://msdn.microsoft.com/en-us/goglobal/bb896001.aspx). I was able to reproduce your issue on my "English (United States)" box (Windows code page 1252). I'm curious if you have the same problem running the package on a machine with the "Japanese (Japan)" locale (Windows code page 932) as that matches the source/target column collation. I don't have a system to test this on but it may be that SMO, which SSIS uses under the covers for the Transfer Objects Task, uses that code page to translate non-Unicode characters instead of the column collation. I'll continue to monitor this thead for your results but maybe someone else can chime in before then. Dan Guzman, SQL Server MVP, http://weblogs.sqlteam.com/dang/
July 13th, 2012 8:03am

The destination column is of type varchar, so when I'm back from vacation, I'll try your suggestion. Thank you. - Hynne
Free Windows Admin Tool Kit Click here and download it now
July 13th, 2012 11:33am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics