Chinese chars through stored procedures...

[Etienne M. St-Georges]

Hi,
I have a problem with my Stored Procedures...
Recently we decided to change the type of our column in our databse from
varchar to nvarchar because of new customers (chinese).
Everything works fine EXCEPT the stored procedures... When i try to pass
chinese characters for a simple SP that those a basic insert in my table, it
inserts ??? instead of chinese characters...
Did i miss something obvious?
Thanks a lot!
Etienne

p.s.: you can email me at et***************@hotmail.com or reply on this
newsgroup.

[Dave Hau]

Check the source code of your stored procedure to make sure the parameter is
declared as nvarchar and not varchar.

HTH,
Dave
"Etienne M. St-Georges" <no************@emstg.com> wrote in message
news:MO*********************@news20.bellglobal.com ...

Hi,
I have a problem with my Stored Procedures...
Recently we decided to change the type of our column in our databse from
varchar to nvarchar because of new customers (chinese).
Everything works fine EXCEPT the stored procedures... When i try to pass
chinese characters for a simple SP that those a basic insert in my table, it inserts ??? instead of chinese characters...
Did i miss something obvious?
Thanks a lot!
Etienne

p.s.: you can email me at et***************@hotmail.com or reply on this
newsgroup.