开发者

SubScript in SQL Server Data

开发者 https://www.devze.com 2023-03-10 06:51 出处:网络
I am trying for SQL server data having a subscript. Below is what 开发者_如何学JAVAi am looking at :

I am trying for SQL server data having a subscript.

Below is what 开发者_如何学JAVAi am looking at : Can we add ‘OS’ within brackets in a smaller font like ‘X (OS)’ or ‘(OS)’ where ever applicable in the brand level columns?


Yes, it you use nvarchar and the correct subscript/superscript characters.

DECLARE @test1 nvarchar(100),  @test2 varchar(100)
SET @test1 = N'Superx₀x₁x₂x₃x⁶x⁷x⁸xₒ' --OK
SET @test2 = 'Superx₀x₁x₂x₃x⁶x⁷x⁸xₒ' --broken
SELECT @test1, @test2

Edit: as per comment to question: formatting normal chars as subscript is a client problem

0

精彩评论

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

关注公众号