Discussion:
Urgent!, char_convert is not recognized SET statement
(too old to reply)
s***@gmail.com
2017-12-20 12:51:54 UTC
Permalink
Hi,

could you please help me with the char_convert.
i am trying to convert sybase code into sql server 2016 and i am getting below error:

'CHAR_CONVERT' is not a recognized SET option.

sybase code:
CREATE PROCEDURE dbo.up_disable_charset
AS
BEGIN
-- disable client-side character conversion
SET char_convert OFF
PRINT "Client-side character conversion turned off."
RETURN 0

go
Erland Sommarskog
2017-12-20 19:43:10 UTC
Permalink
Post by s***@gmail.com
could you please help me with the char_convert.
'CHAR_CONVERT' is not a recognized SET option.
CREATE PROCEDURE dbo.up_disable_charset
AS
BEGIN
-- disable client-side character conversion
SET char_convert OFF
PRINT "Client-side character conversion turned off."
RETURN 0
go
SET CHAR_CONVERT ON /OFF has no direct correspondence in SQL Server. You
first need to determine what you want to achieve on a higher level, before
you can look at solutions in SQL Server. That is, you cannot get what
you want, until you know what you want.

By the way, in SQL Server "" delimits identifiers. Use single quotes
to delimit string literals.

Loading...