 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
SQL Server Forum / Other Technologies / Full-Text Search / March 2005Does any one have similar problem with nvarchar column storing chinese characters?
I am running into some wired problem with nvarchar(4000). When I insert the chinese characters, the text got cut off. The following two sections shows what happen, the first chinese section is what is ended up in the database, the second section (separate by "--------------------") show the complete parameter value before IDbCommand.ExecuateQuery() is called. It is less than 4000 bytes. It seems a chunk of text got loss somewhere. No sure what happen here. But it seems to be a serious problem. My full text search certainlly wouldn't work if I can't get the data into the column. Is this a bug in 2005 CTP or something I did wrong ? Thanks --Xin Chen ?????-???????? - ?? - ?? - ??- ?? - ?Q - ??- ? - ?? - ??- ?? - ?? ???? > ???? > ???? ????? ??:2005?03?23?03:56????:??????????????????? ?? ????????????????????? ????????????? ???????1937?12?13??27???????????,???????? ???????,??????,????????? ---------------------------------------------------------------------------- --------------- "? ?????-???????? - ?? - ?? - ??- ?? - ?Q - ??- ? ? - ?? - ??- ?? - ?? ???? > ???? > ???? ?????\n ??:2005?03?23?03:56????:??????????????????? ??\n????????????????????? \n \n????????? ???? \n ???????1937?12?13??27???????????,?? ?????????????,??????,???????????,????? ?????????????????????,???????30??????? ?,???????????,?????,?????,???????,???? ???????????1938?3?24?,?????????????????,? ?????2????31?????? ?????????,??????27?,?? ??????????,?31????????,???????28?,?????? ????31???,???????29?,??????2??????????,? ????????,???2???????????31?,??????????? ??????4?3?,?????????????????????,?????? ?????????????,?????,?????????????????? 6??,???????????????7???,??????????????? ??,??????????????????????????????????? ??????,???????????,????4.6??,????7500???? ?????????,???????1???????????????????? ???????,??????????????? ????\n ???????? ????????\n ????????? ?????????????????? ?????????????\n?????????????? ???????? \n????????????? ?????????\n???????????3-26 ?? ???????\n????????????? ?????????\n???? ????????? ?????????\n???:?????? ??????<? ????> \n ???? ??????????"?"?????????:? ? ?????? ???? \n -- ????? ChinaRen - ??? - ???? - ?? ?? - ???? - ???? - ???? - ???? - ????? - About SOHU - ????\nCopyright ? 2005 Sohu.com Inc.All rights reserved." how are you inserting these characters? OpenRowset?  SignatureHilary Cotter Looking for a SQL Server replication book? http://www.nwsu.com/0974973602.html Looking for a FAQ on Indexing Services/SQL FTS http://www.indexserverfaq.com > I am running into some wired problem with nvarchar(4000). When I insert the > chinese characters, the text got cut off. The following two sections shows [quoted text clipped - 51 lines] > ?? - ???? - ???? - ???? - ???? - ????? - About SOHU - > ????\nCopyright ? 2005 Sohu.com Inc.All rights reserved." no, I am using a store proc and call it via ADO.NET in my app I store my text in the nvarchar(4000) as string, I am not using openrowset. the stored proc use regular insert into (...) values (...) --Xin Chen > how are you inserting these characters? OpenRowset? > [quoted text clipped - 57 lines] > > ?? - ???? - ???? - ???? - ???? - ????? - About SOHU - > > ????\nCopyright ?2005 Sohu.com Inc.All rights reserved." |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.