How to store DBCS characters in Database

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 2000 Forums

SQL Server Development (2000)

How to store DBCS characters in Database

Author

Topic

vgr.raju
Yak Posting Veteran

95 Posts

Posted - 2006-01-03 : 13:31:28

I have the simple stored procedure which inserts the record into the table.
The execution of the stored procedure:
DECLARE @RC int
DECLARE @CustomerID nvarchar(50)
DECLARE @CompanyName nvarchar(40)
DECLARE @ContactName nvarchar(30)
DECLARE @ContactTitle nvarchar(30)
DECLARE @Address nvarchar(60)
DECLARE @City nvarchar(50)
DECLARE @Region nvarchar(50)
DECLARE @PostalCode nvarchar(50)
DECLARE @Country nvarchar(50)
DECLARE @Phone nvarchar(50)
DECLARE @Fax nvarchar(50)

-- TODO: Set parameter values here.

EXECUTE @RC = [Northwind].[dbo].[SetCustomerAccount]
@CustomerID='ƒIƒŠ'
,@CompanyName='ƒIƒŠ'

When I execute the above stored procedure,I get the record created in the table ,but the characters are saved as '???'.
THE ACCOUNT DOES NOT EXIST:CREATING NEW ACCOUNT FOR CUSTOMERID ??
The customerid becomes '??'.
I have selected the collation SQL_Latin1_General_CP1_CI_AS for that column.Is there anyway I can insert the records with different collations to the same table?I would appreciate your help in this regards.

Thanks!
Raju

Kristen
Test

22859 Posts

Posted - 2006-01-04 : 07:37:12

will:

@CustomerID= N'ƒIƒŠ'

enforce the UNICODE in that "string constant" ?

Kristen

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources