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)
 Create stored procedure with unicode utf-8

Author  Topic 

asafg
Starting Member

39 Posts

Posted - 2009-03-17 : 07:33:17
I googled the subject but now I'm even more confused.

when I copy my code to word non-english characters become gibrish.

I want to use utf-8 - is it possible to define the char set when creating a new SP (and not the default 1200??? - I think this is the one )

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2009-03-17 : 07:43:56
There is no option for specifying char set when defining SP.
But you can specify desired encoding while saving query as a .sql file.

Harsh Athalye
India.
"The IMPOSSIBLE is often UNTRIED"
Go to Top of Page

asafg
Starting Member

39 Posts

Posted - 2009-03-17 : 09:19:11
Thanks Harsh

I was hoping that it's possible ... I guess I'll have to continue using my magic converter - notepad - from some reason after pasting the code is notepad coping again and pasting it in winword - there is no gibrish ?!?!

About the sql file encoding...
I asked before and maybe you know the answer... in the save as I can change the encoding - but I have to do this every time - can I set the default encoding?

Thanks Again
Go to Top of Page
   

- Advertisement -