Unicode

[shramana]

Hi,
We have a datamart in SQL Server. Any SQL with a unicode filter does not return data.
Sample SQL
select * from dbo.dim_addr_mtch_mstr
where org_full_nm = '??????'

I can get results back if i prefix a N before the literal.
select * from dbo.dim_addr_mtch_mstr
where org_full_nm = N??????'

In our case, the problem is the SQL is dynamically generated by a reporting tool and it is not possible to prefix a N before string literals. Is there any default character code setting at the database level that enables the SQL server to treat the literals as unicode without prefixing 'N'.
thanks,
Shramana

 

[mrdenny]

Nope, you need to put it there manually.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

(Not quite so old any more.)