declare @mat_name varchar(200),@len1 int,@len2 int
set @mat_name='Khí Argon'
select len1=len(replace(@mat_name,' ',''))
select len2=datalength(replace(@mat_name,' ',''))
--len1与len2不相等的话说明有中文
--SQL查询字段:
select case when len(cast(replace(MAT_VIEW.MAT_NAME,' ','') as varchar(500))) = datalength(cast(replace(MAT_VIEW.MAT_NAME,' ','') as varchar(500))) then 'N' else 'Y' end as is_chinese_mat,
* from MAT_VIEW
SQL server 判断字符串是否有中文
于 2022-09-28 17:28:21 首次发布