A bug in Oracle using the CAST () function

Today, when using Oracle, I accidentally found a small problem, that is, when using the cast function to convert the type, the text is truncated, now posted, as follows:

Select Cast (' not filled ' as Nvarchar2 () as Hg from Dual

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M01/40/B8/wKioL1PPUU3CYE7PAAAb5fvsVpw620.png "title=" 11.PNG "alt=" Wkiom1pptiljxrtraaawoo1yxw4206.png "/>

Select Cast (' not filled in ' as Nvarchar2) as Hg from Dual

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M02/40/B4/wKioL1PPThqB99e_AAAc317N1a8622.png "style=" float: none; "title=" 21.PNG "alt=" Wkiol1ppthqb99e_aaac317n1a8622.png "/>

Select Cast (' not filled in what ' as Nvarchar2 () as Hg from Dual

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M01/40/B4/wKiom1PPTQCwhwN4AAAadATmDTU219.png "style=" float: none; "title=" 31.PNG "alt=" Wkiom1pptqcwhwn4aaaadatmdtu219.png "/>

Conclusion: Some Chinese are truncated, such as testing with ' Please select ', ' non-nuclear tube ', and ' What ' can be displayed normally, has ruled out length and character set problems, and its Varchar,varchar2,nvarchar type does not have this problem.

This article is from the "front-end technical article Application Sharing" blog, please be sure to keep this source http://viphyy.blog.51cto.com/6403455/1445085

A bug in Oracle using the CAST () function