Groups > microsoft.public.sqlserver.server > #18827

Re: Urgent!, char_convert is not recognized SET statement

From	Erland Sommarskog <esquel@sommarskog.se>
Newsgroups	microsoft.public.sqlserver.server
Subject	Re: Urgent!, char_convert is not recognized SET statement
Date	2017-12-20 20:43 +0100
Organization	Erland Sommarskog
Message-ID	<XnsA851D2C59A5CEYazorman@127.0.0.1> (permalink)
References	<#u5fbVs$CHA.1612@TK2MSFTNGP11.phx.gbl> <eCeUCvs$CHA.33376@TK2MSFTNGP10.phx.gbl> <#bM4czs$CHA.2132@TK2MSFTNGP11.phx.gbl> <a49ddf07-6939-423b-b03c-3e38f5d6abc3@googlegroups.com>

Show all headers | View raw

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

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.

Back to microsoft.public.sqlserver.server | Previous | Next — Previous in thread | Find similar

Thread

Re: Urgent!, char_convert is not recognized SET statement sandeepcd94@gmail.com - 2017-12-20 04:51 -0800
  Re: Urgent!, char_convert is not recognized SET statement Erland Sommarskog <esquel@sommarskog.se> - 2017-12-20 20:43 +0100

csiph-web