We have the following situation:- SQL Server 2008 (German Version)- linked Server to Pervasive database

The linked server performs not very fast, but is stable and working.On this server somebody created a view with a special character 'Ä'. In object explorer this character is shown as a questionmark '?'.If i query the view exactly how it is shown in object explorer the following errors appeared:(sorry server in German, setup of this server was not by me.....)

Does anybody have an idea how this view can be accessed with an escape character ?All other tables work well.A sample query looks like this and works:SELECT * FROM OPENQUERY(LinkedServer,'SELECT *FROM "customers"')

I think there is all OK with the collation.The problem ist only with this single view and this character.I thought there is an option with something like an escape character where it would be possible to pass the special character as hex or decimal.

Hmmm . . . there's a function called CHAR that might be what you're asking about. (Not sure if this is what you need, but what the heck.)

What it does is it takes a number representing an ASCII value and converts it to a character. For example, "select char(35)" gives you "#". Take a look at it in BOL (Books Online) and see if it's what you need.

I took three years of German in high school (Gymnasium) and one semester of German in college (Universität). It's been a long time since I practiced it!