After Execute Store Producedure I get ????? - SQL Server Forums

Home | Weblogs | Forums

Site Sponsored By: SQLDSC - SQL Server Desired State Configuration

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

General SQL Server Forums

New to SQL Server Programming

After Execute Store Producedure I get ?????

Author

Topic

Ciwan21
Starting Member

7 Posts

Posted - 2009-04-27 : 07:37:47

Hi there,

I am doing localisation and linked from Microsoft Access to SQL Server 2000. After i ran the store procedure i get in the Master Table in the russian column i get ???? instead of Russian letters. could any one help me how i get around it?

this is my stroe procedure

CREATE PROCEDURE usp_Import_Russian AS

Declare @strEnglish as varchar(500)
Declare @strOtherLanguage as char(500)

Declare csrFromMaster Cursor for

(SELECT English, Russian
FROM importarea

)

Open csrFromMaster
Print ' Open Cursor '
FETCH NEXT FROM csrFromMaster into @strEnglish, @strOtherLanguage

WHILE (@@FETCH_STATUS=0)
BEGIN
print @strOtherLanguage
UPDATE tblSystem_Localisation_MASTER
SET Russian = @strOtherLanguage
WHERE (English = @strEnglish)

FETCH NEXT FROM csrFromMaster into @strEnglish, @strOtherLanguage
end
CLOSE csrFromMaster
DEALLOCATE csrFromMaster
GO

Any help would be appreciated.
Thanks

finding out is better

TG
Master Smack Fu Yak Hacker

6065 Posts

Posted - 2009-04-27 : 09:59:59

I don't think you need a CURSOR for this. If [importarea].[russian] column contains non-english characters then you need to declare your @strOtherLanguage variable a nVarchar. instead of char or varchar.

EDIT:
and of course the target table column datatype needs to support unicode (nvarchar) as well.

Be One with the Optimizer
TG

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources