Printing ™ character - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

Printing ™ character

Author

Topic

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-04-23 : 09:31:45

does anybody know why trying to print ™ character in 2005 does not work while same works in SQL 2000? The ascii value is 153

SELECT CHAR(153) returns ™ in sql 2000 but Ö in 2005.

dass05555
Yak Posting Veteran

55 Posts

Posted - 2008-04-23 : 09:36:19

HI friend,

i'm using sql server 2005 only,
for me the query 'SELECT CHAR(153)'
returning ™ only
juzz chk it out clearly.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-04-23 : 09:40:38

Thanks for the quick response friend. Sorry not working for me my friend. However it works when i try it on a 2000 server.Also i'm using SSMS to connect to 2005 server and QA to connect to 2000 server

elancaster
A very urgent SQL Yakette

1208 Posts

Posted - 2008-04-23 : 10:17:00

ok... not something i have a great deal of experience with actually but FTR, i'm using 2005 and the result of char(153) on my system is still 'tm'

useful links?

http://www.asciitable.com/

http://www.web-source.net/symbols.htm

you can the difference in the 2 there but i'm no clearer why to be honest

Em

tm
Posting Yak Master

160 Posts

Posted - 2008-04-23 : 10:41:42

I am not totally sure but was wondering if it could be your collation/code page.

run .. sp_helpsort

This will give your collation and code page you are using for your server. You should be able to compare if your SQL 2000 server is setup differntly than SQL 2005.

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2008-04-23 : 11:03:54

Alt+153 gives character Ö for me.
Alt+0153 gives character ™ for me.

E 12°55'05.25"
N 56°04'39.16"

Arnold Fribble
Yak-finder General

1961 Posts

Posted - 2008-04-23 : 12:49:05

Sounds like the default collation for the SQL Server 2005 installation is something that uses Code page 850 like SQL_Latin1_General_Cp850_CI_AS.

There's no trademark character in Cp850. If you are trying to insert a TM character into a column that can contain it, use its Unicode codepoint: NCHAR(8482).

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-04-23 : 23:43:10

Thanks all for the responses.

Arnold the problem was with the collation setting of the server. I used your solution and it works like a charm. Cheers.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources