Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Exclamation Marks

Status
Not open for further replies.
umbogo

umbogo

IS-IT--Management
Oct 21, 2003
11
US
I am using Mercator to insert records into an Adaptive Server Anywhere Enterprise table and am losing exclamation marks.

Specifically: when I try to insert !SPZ3 into a varchar column I get the following results:

Input Sybase
!SPZ3 SPZ3
'!SPZ3' 'SPZ3'
'!SPZ3 'SPZ3'
"!SPZ3" "SPZ3"
!!SPZ3 !SPZ3
!!!SPZ3 !SPZ3
!!!!SPZ3 !!SPZ3
!!!!!!!!SPZ3 !!!!SPZ3
\!SPZ3 \SPZ3

I suspect that "!" is an escape character in Sybase, i.e. it will ignore the literal "!" unless I precede it with escape character "!".

Can anyone confirm this?

Thanks.
 
Sort by date Sort by votes
No, "!" is not an escape character in Sybase. The ESCAPE keyword can be used to define this (for a given string), but that will not be your problem.

It is almost certainly your Mercator middleware that is causing this issue.
 
Upvote 0 Downvote
As it turns out it was both: my Sybase DBA is using it as an escape character, and my middleware was too and was putting too many in.Thanks for the reply.
 
Upvote 0 Downvote
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top