INF: ??? ???? SQL ?? ????? ???? DBCS

?????? ????????? ?????? ?????????
???? ???????: 155723 - ??? ???????? ???? ????? ????? ??? ???????.
????? ???? | ?? ????

??????

??? ???? ?????? ?????? (DBCS) ??? ????? ?????? ????? ???? ???? ?? ???? ?????? ??? ???? char ?? varchar ??? ?????? ???????? ??? ????? ??? ??????. ?? ???? ??????? Microsoft SQL Server ???? ???? DBCS ???? ?????? ??? ???? ?? ??? ???? ?????? ?????? ? ??? ????? ??? ???? ????? ??????.

???? ??????? ?????? ??????? ??? ????????. ?? ??????? ?? ???? ?????? ???? ??? ????? ??? ???? ???? DBCS.
CREATE TABLE test
(
  col1 char (10),
  col1 varchar (10)
)
GO

/* Let D represent a double character. */ 
/* Let L represent the leading byte.   */ 
/* Let T represent the trailing byte.  */ 
/* Let S represent a single character. */ 
/* Let s represent space (ASCII 20).   */ 

INSERT test VALUES ("SDDDDD", "SDDDDD")
GO
SELECT * FROM test
GO
				

col1       col2
---------- ----------
SLTLTLTLTs SLTLTLTLT
				
???? ????? ????? ???????? ???? ?? ??? ???? ?????? ?????? ????? ???? ?? ???? ???? ????? ???? ????? char ????? ???????? ???????? ????? varchar ?????? ?? ????? ?????? ?????.

???????

???? ???????: 155723 - ????? ??? ??????: 05/????/1426 - ??????: 3.3
????? ???
  • Microsoft SQL Server 7.0 Standard Edition
  • Microsoft SQL Server 6.5 Standard Edition
  • Microsoft SQL Server 2000 Standard Edition
????? ??????: 
kbmt kbinfo kbprogramming KB155723 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????155723

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

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com