Junk characters coming doing query from oracle server

Question

Junk characters coming doing query from oracle server

suresh.guglani

SSC Enthusiast

Points: 141
More actions
July 2, 2011 at 5:58 am

#252948

While doing query to oracle through linked server degree symbol(°) is getting converted to question symbol(¿) .
I have set remote collation to true in linked server definition & the character set for oracle is
NLS_NCHAR_CHARACTERSET= AL16UTF16
NLS_LANGUAGE= AMERICAN
NLS_TERRITORY= AMERICA
NLS_CHARACTERSET= US7ASCII

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Gift Peddie SSC Guru Points: 73570 More actions · Answer 1

suresh.guglani (7/2/2011)
While doing query to oracle through linked server degree symbol(°) is getting converted to question symbol(¿) .
I have set remote collation to true in linked server definition & the character set for oracle is
NLS_NCHAR_CHARACTERSET= AL16UTF16
NLS_LANGUAGE= AMERICAN
NLS_TERRITORY= AMERICA
NLS_CHARACTERSET= US7ASCII

You are getting character conversion and it may be related to both collation and delimiter so set correct Windows collation and ANSI SQL delimiters. In SQL Server 2008 you can add the collation in the T-SQL code so SQL Server will do your evaluation based on the defined collation of the column. If you have not defined the collation go into design of the table properties and change the collation.

Kind regards,
Gift Peddie

Bruce W Cassidy SSChampion Points: 12668 More actions · Answer 2

Also I'm not sure the degree symbol fits into the 7-bit ASCII character set:

NLS_CHARACTERSET= US7ASCII

PaulB-TheOneAndOnly SSC Guru Points: 66772 More actions · Answer 3

Bruce W Cassidy (7/6/2011)
Also I'm not sure the degree symbol fits into the 7-bit ASCII character set:
NLS_CHARACTERSET= US7ASCII

That's why configuration also includes alternative "National" Character Set set to AL16UTF16...

NLS_NCHAR_CHARACTERSET= AL16UTF16

_____________________________________
Pablo (Paul) Berzukov

Author of Understanding Database Administration available at Amazon and other bookstores.

Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.