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.
| Author |
Topic |
|
Zoran10
Starting Member
2 Posts |
 Posted - 2011-01-10 : 07:43:52
|
| Hi,I have following snippet of code inside stored procedure:declare @sql nvarchar(max)set @sql = N'exec (''select p.ColumnA [CyrillicCaptionA], P.ColumnB[CyrillicCaptionB] from dbo.#someTable p'' )'The problem:When previous code is executed each cyrillic character in column caption is replaced by question mark. I have similar code inside another procedure and it works fine. How can I fix this problem ?Thanks |
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2011-01-10 : 08:17:07
|
| Hm, peculiar way of executing the dynamic sql...why the "double dynamics"...?What are the data types in #someTable? Are you sure that the front end application is formatted right...?- LumbagoMy blog (yes, I have a blog now! just not that much content yet) -> www.thefirstsql.com |
 |
|
|
|
|
|
Problem with cyrillic characters in column caption