FIX: FOR ????? XML: ?? ??? ??????? ??? "????? ???????" ?? xmltext ??? ????? xmltext DBCS

???? ???????: 290083 - ??? ???????? ???? ????? ????? ??? ???????.
????? ???????? ????? ????? ??????? ?????? ?????? ???????
????? ???: 236233 (SHILOH_BUGS)
????? ???? | ?? ????

???????

?? ??? XML ????? ???? ?????? ?? xmltext ????? ???? ?????? ?????? ??? ?????? ?????? (DBCS) ? ??????? ?? ??? ??????? ??? ????? ????? ?????? ?? XML ??? ???? ???? ???.
???? ??? ?????? | ????? ???????

????

??? ??? ???????? ??? ?????? ??? ???? ???? ???? ?? SQL Server 2000. ?????? ??? ??????? ??????? ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:
290211
(http://support.microsoft.com/kb/290211/EN-US/ )
INF: ????? ?????? ??? ???? ???? ???? ??????? SQL Server 2000
???? ??? ?????? | ????? ???????

?????

???? Microsoft ?? ??? ????? ?? SQL Server 2000. ?? ????? ??? ??????? ???? ??? ?? SQL Server 2000 Service Pack 1.
???? ??? ?????? | ????? ???????

??????? ????

?? ??? XML ????? ?????? ??????? ??? ??? ???? ???? ?? ??????? ???? xmltext ?????? ??????? ??? ??? ????? ?????? ????? ?? xmltext ??? ????? ?? ??????? ????. ??? ???? ????? ?? DBCS ??? ???? ????? ????? ?? ??? ??????? ??? ???? ????? ?? ?????. ???? ??? ?? XML ??? ???? ???? ???.

????? ????? ??? ?????? ????? ???? ????? ?? ?? ????????? ?????? ??? ???: 
create table T1 (F0 int primary key, F1 TEXT collate Japanese_CI_AS)
go
insert into T1 values (111, '<elt1 att0="222" att1="?"><elt2 att2="?" /></elt1>')
go
select 1 as TAG, 0 as parent, F1 as [elt1!1!!xmltext], F0 as [elt1!1!att0] from T1 for xml explicit
??? ????? ?????? 
-- [INCORRECT RESULT] - att0 is not overwritten.

XML_F52E2B61-18A1-11d1-B105-00805F49916B                                                                                                                                                                                                                         
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 
<elt1 att0="111" att0="222" att1="?"><elt2 att2="?" /></elt1>
????? ??? ?? ???? ??????? ???????? ??? ???: 
-- [EXPECTED  RESULT] - att0="222" is overwritten with att0="111"

XML_F52E2B61-18A1-11d1-B105-00805F49916B                                                                                                                                                                                                                         
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 
 <elt1 att0="111" att1="?"><elt2 att2="?" /></elt1>
???? ??? ?????? | ????? ???????

???????

???? ???????: 290083 - ????? ??? ??????: 12/?????/1424 - ??????: 3.2
????? ???
  • Microsoft SQL Server 2000 Standard Edition
????? ??????: 
kbmt kbbug kbfix kbsqlserv2000sp1fix KB290083 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????290083
(http://support.microsoft.com/kb/290083/en-us/ )
???? ??? ?????? | ????? ???????

????? ???????

 
???? ??? ?????????? ??? ??????