Ascii conversion difficulty -- sql server mseq

Mark
1/21/2004 12:57:35 PM

These queries:
select ascii('╝');
select ascii('+');
select char(43);

return "43, 43, +" respectively.

These queries:

select * from tbl where field = '╝'
select * from tbl where field like '╝'
select * from tbl where PARTINDEX('╝', field)>0

return results as if I was asking for '+'.

Does anyone know how I can single out for this strange
character? Access seems to be able to handle this, but

Mark
1/21/2004 1:14:38 PM

Just a follow-up...

When I wrote this message I was pasting this single
strange character. When I view my post through the
browser, it looks like a whole set of characters ->
╝ When I reply to the original message I can see
the character I was refering to as a single character...

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server mseq

sql server mseq : Ascii conversion difficulty