Backup is not restored well on SQL server
Hi,
I tried following things.
1. on RTC with Derby
repotools -export toFile=export.tar
2. on RTC with DB2
repotools -import fromFile=export.tar
3. on RTC with SQL server
repotools -import fromFile=export.tar
On RTC with DB2, backuped data was restored well but on RTC with SQL server, the data was was not restored properly.
Is this known problem?
I tried following things.
1. on RTC with Derby
repotools -export toFile=export.tar
2. on RTC with DB2
repotools -import fromFile=export.tar
3. on RTC with SQL server
repotools -import fromFile=export.tar
On RTC with DB2, backuped data was restored well but on RTC with SQL server, the data was was not restored properly.
Is this known problem?
2 answers
I found the cause.
The cause was this setting.
ALTER DATABASE jazz COLLATE SQL_Latin1_General_CP437_CS_AS
GO
When Japanese character is used, the collation needs to be set as Japanese character can be used.
Currently I set it Japanese_CI_AS.
Please let me know what collation I truly should set to use Japanese character.
The cause was this setting.
ALTER DATABASE jazz COLLATE SQL_Latin1_General_CP437_CS_AS
GO
When Japanese character is used, the collation needs to be set as Japanese character can be used.
Currently I set it Japanese_CI_AS.
Please let me know what collation I truly should set to use Japanese character.
Could anyone answer this?
Only following information can be seen in Information Center.
--------------------------------------------------------------------------------
3. Change the collation of the Jazz Team Server database. From the command line tool, type:
ALTER DATABASE jazz COLLATE SQL_Latin1_General_CP437_CS_AS
GO
--------------------------------------------------------------------------------
Does it mean the environment of SQL server with Japanese characters is not supported on RTC?
Only following information can be seen in Information Center.
--------------------------------------------------------------------------------
3. Change the collation of the Jazz Team Server database. From the command line tool, type:
ALTER DATABASE jazz COLLATE SQL_Latin1_General_CP437_CS_AS
GO
--------------------------------------------------------------------------------
Does it mean the environment of SQL server with Japanese characters is not supported on RTC?