what am i doing wrong -- char(240)

Question

what am i doing wrong -- char(240)

goher2000

SSCertifiable

Points: 5479
More actions
January 16, 2018 at 1:40 pm

#325489

what I am doing wrong, why the result is '=' ?
declare @C table ( c1 varchar(10) )
insert into @C select '≡'
select * from @C

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 1

goher2000 - Tuesday, January 16, 2018 1:40 PM
what I am doing wrong, why the result is '=' ?
declare @C table ( c1 varchar(10) )
insert into @C select 'â‰¡'
select * from @C

Try this:

declare @C table ( c1 nvarchar(10) )

insert into @C select N'â‰¡'

select * from @C

Luis Cazares SSC Guru Points: 183706 More actions · Answer 2

goher2000 - Tuesday, January 16, 2018 1:40 PM
what I am doing wrong, why the result is '=' ?
declare @C table ( c1 varchar(10) )
insert into @C select 'â‰¡'
select * from @C

You need to add some N's to handle unicode characters.
declare @C table ( c1 NVARCHAR(10) ) insert into @C select N'â‰¡'

select * from @C

Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

How to post data/code on a forum to get the best help: Option 1 / Option 2

goher2000 SSCertifiable Points: 5479 More actions · Answer 3

it didn't work, probably something to do with collation, I am on SQL_Latin1_General_CP1_CI_AS

print CONVERT(VARCHAR(3), ASCII('=')) + ' = ' + CHAR(240)

print CONVERT(VARCHAR(3), ASCII(N'=')) + ' = ' + CHAR(240)

RandomStream Hall of Fame Points: 3735 More actions · Answer 4

goher2000 - Tuesday, January 16, 2018 2:03 PM
it didn't work, probably something to do with collation, I am on SQL_Latin1_General_CP1_CI_AS
print CONVERT(VARCHAR(3), ASCII('â‰¡')) + ' = ' + CHAR(240)
print CONVERT(VARCHAR(3), ASCII(N'â‰¡')) + ' = ' + CHAR(240)

Try

print nchar(0x2261)

drew.allen SSC Guru Points: 76985 More actions · Answer 5

goher2000 - Tuesday, January 16, 2018 2:03 PM
it didn't work, probably something to do with collation, I am on SQL_Latin1_General_CP1_CI_AS
print CONVERT(VARCHAR(3), ASCII('â‰¡')) + ' = ' + CHAR(240)
print CONVERT(VARCHAR(3), ASCII(N'â‰¡')) + ' = ' + CHAR(240)

You need to use N'â‰¡' instead of 'â‰¡'. You need to use UNICODE() instead of ASCII. You need to use NVARCHAR(4) instead of VARCHAR(3).

SELECT CONVERT(NVARCHAR(5), UNICODE(N'â‰¡')) + ' = ' + CHAR(240)

Drew

J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA

goher2000 SSCertifiable Points: 5479 More actions · Answer 6

goher2000

SSCertifiable

Points: 5479

January 17, 2018 at 7:06 am

#1976117

thanks guys