char translation problem - 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

SQL Server Administration (2005)

char translation problem

Author

Topic

rsegoviano
Starting Member

2 Posts

Posted - 2011-02-25 : 14:17:24

when I enter char(165) 'Ñ' in a column in a table, sql translate automatic to char(209)'Ñ', but when I put this character in a printer it is showed as a graphic character (double horizontal line with a vertical line below). I found in the sql help that is there a autotranslation of character data but I don't know where and how to change it.

Can someone help me ?

Thanks in advance

Roberto Segoviano
Mexico

TG
Master Smack Fu Yak Hacker

6065 Posts

Posted - 2011-02-25 : 16:15:29

Looks to me like only 209 is the 'Ñ'. What happens if you enter that character in your table instead of 165?


select char(165) [165], char(209) [209]

OUTPUT:

165  209
---- ----
¥    Ñ

Be One with the Optimizer
TG

rsegoviano
Starting Member

2 Posts

Posted - 2011-02-25 : 20:13:42

Thanks TG :

The answer at the SQL select is the same like you : 165 ¥ and 209 Ñ (when I type Alt+165 in my keyboard the answer is Ñ and Alt+209 is Ð). But the printed answer (in paper) is 165 = Ñ and 209 = - . I make a interesting experiment : I create a empty row of a table and make the next SELECT name, ascii(left(name,1)) and when I type ALT+165 at the field it appear like Ñ but the ascii is 209 and my printer show as -

A poor solution is to make some code like (powerbuilder) :

li_pos=pos(name,'Ñ',1)
if li_pos>1 then
name=mid(name,1,li_pos-1)+chr(165)+mid(name,li_pos+1)
endif

in plain words is searching for a chr(209) and replace at the print line as a chr(165)

Thanks

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources