开发者

Can Unicode compression in SQL 2008 R2 cause GUIDs to become corrupt?

We recently had some trouble with our production SQL 2008 R2 databases and had to failover to log-shipped warm spares for most of our databases. This morning I found some very odd GUID values scattered throughout our set of databases. For background, we have a main clients database, that holds various information about installed clients, including the master client_guid that is referenced in other tables and other databases. I am seeing that the GUIDs in some of the support dbs have become corrupted with Kanji and Cyrillic characters. For example: In our main client data table, a particular record had a GUID of '4d86854e-d699-4bce-a98b-c34fcc909453', but in the Analytics database that same GUID is showing up as '4d86854e-d699-4bce瞧RĹ(Ɏ-c34fcc909453'.

I have been wracking my brain today trying to figure out how this might have happened. I stumbled upon some information about Unicode compression, and I was wondering if it might be possible for SQL Server to mangle these GUIDs during a database restore.

Collation thr开发者_如何转开发oughout our db system is set to SQL_Latin1_General_CP1_CI_AS.

I'm wondering if anyone has any insight into this problem.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜