ASE Database forum - Why capitalizing

Author

Why capitalizing

Charles Bonsu

2005-04-29, 9:25 am

INSERT INTO csd.gtr_part_type (part_type_code,
part_type_txt,
last_updt_user)

VALUES ('1', 'Non-Federal, Non-Local, Attending On-Site',
'grupd')

A query on this table in production gives the following
result.

1 Non-Federal, Non-Local, AttEnding On-Site
gtrupd

Why is the E in Attending being capitalized

Jeffrey R. Garbus

2005-04-29, 11:26 am

Funny character in the input stream?

What version Sybase are you running?

<Charles Bonsu> wrote in message news:42724171.11a1.1681692777@sybase.com...
> INSERT INTO csd.gtr_part_type (part_type_code,
> part_type_txt,
> last_updt_user)
>
> VALUES ('1', 'Non-Federal, Non-Local, Attending On-Site',
> 'grupd')
>
>
>
> A query on this table in production gives the following
> result.
>
> 1 Non-Federal, Non-Local, AttEnding On-Site
> gtrupd
>
> Why is the E in Attending being capitalized

Charles Bonsu

2005-04-29, 1:26 pm

Adaptive Server 12.5.0.3

Charles

> Funny character in the input stream?
>
> What version Sybase are you running?
>
> <Charles Bonsu> wrote in message
> csd.gtr_part_type (part_type_code, part_type_txt,
> last_updt_user) >
>
>

Bret Halford

2005-04-30, 9:25 am

Charles, Bonsu wrote:

> INSERT INTO csd.gtr_part_type (part_type_code,
> part_type_txt,
> last_updt_user)
>
> VALUES ('1', 'Non-Federal, Non-Local, Attending On-Site',
> 'grupd')
>
> A query on this table in production gives the following
> result.
>
> 1 Non-Federal, Non-Local, AttEnding On-Site
> gtrupd
>
> Why is the E in Attending being capitalized

Are you sure you are looking at the same row of data that was inserted?
I see that "grupd" has changed to "gtrupd" as well.

The one other possibility that comes to mind is that there
might be an insert trigger on the table that is modifying the
data being inserted.

If that isn't it, could you post a complete example - run something like

the following and post the complete session:

-- show there is no existing row.(use the same WHERE clause
-- as used in the SELECT following the INSERT below)
select * from csd.gtr_part_type WHERE part_type_code = 1
go
-- Insert your row of data
INSERT INTO csd.gtr_part_type (part_type_code,
part_type_txt,
last_updt_user)

VALUES ('1', 'Non-Federal, Non-Local, Attending On-Site','grupd')
go
-- show the row that was inserted (use the same WHERE clause
-- as in the SELECT above)
select * from csd.gtr_part_type WHERE part_type_code = 1
go

Jason L. Froebe - Team Sybase

2005-05-08, 8:24 pm

Charles wrote:
> INSERT INTO csd.gtr_part_type (part_type_code,
> part_type_txt,
> last_updt_user)
>
> VALUES ('1', 'Non-Federal, Non-Local, Attending On-Site',
> 'grupd')
>
>
>
> A query on this table in production gives the following
> result.
>
> 1 Non-Federal, Non-Local, AttEnding On-Site
> gtrupd
>
> Why is the E in Attending being capitalized

Hi Charles,

Check for triggers on the table and check if this is a proxy table. Most likely, if you can duplicate the problem using isql (or SQSH), then there is a trigger on the table.

I'm suspecting:

1) trigger
2) client application is being 'helpful'

--
No one has seen what you have seen, and until that happens, we're all going to think that you're nuts. - Jack O'Neil, Stargate SG-1

Jason L. Froebe
Team Sybase member

Sponsored Links