Query to Pervasive linked server with special character in tablename

Question

Query to Pervasive linked server with special character in tablename

Viewing 6 posts - 1 through 7 (of 7 total)

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

Ray K SSC-Dedicated Points: 31172 More actions · Answer 1

Ach du Lieber, ich habe meine Deutsch nicht üben! (I hope I said that right!)

Off the top of my head, I'd suggest checking the collation settings.

+--------------------------------------------------------------------------------------+
Check out my blog at https://pianorayk.wordpress.com/

polarbear101 Old Hand Points: 338 More actions · Answer 2

Hello Ray K

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.

btw: Your german can be understood.....

Ray K SSC-Dedicated Points: 31172 More actions · Answer 3

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!

+--------------------------------------------------------------------------------------+
Check out my blog at https://pianorayk.wordpress.com/

sturner SSC-Insane Points: 22471 More actions · Answer 4

I think I would create a new view that does not have that character in it.

The '?' means it is a unicode character that can't be displayed in the current code page.

The probability of survival is inversely proportional to the angle of arrival.

polarbear101 Old Hand Points: 338 More actions · Answer 5

Thank You for the answers.

Yes it would be the simplest solution to create a new view.

A consultant programmed this view. I have no access to this.

First i wish i could tear the ears of this programmer as long as Mr. Spock's ears.....

Will try with the "CHAR" option, maybe a statement can be prepared.

Ray K SSC-Dedicated Points: 31172 More actions · Answer 6

polarbear101 (12/30/2009)
First i wish i could tear the ears of this programmer as long as Mr. Spock's ears.....

LOL!!!!!!!!!!!!!!!!

I suspect there are many people (myself included) who share your sentiment!!!

+--------------------------------------------------------------------------------------+
Check out my blog at https://pianorayk.wordpress.com/