I probably wrong but won't Oracle just ignore the spaces when doing a
select.
if the column is char(8) and you do
select * from blah where col1 = 'joe'
its still the same as
select * from blah where col1 = 'joe^^^^^' // ^ being spaces
this works in MS SQL Server but that doesn't really mean anything does it :)
joe
----- Original Message -----
From: "Erik G. Dybdahl" <[EMAIL PROTECTED]>
To: "jBoss" <[EMAIL PROTECTED]>
Sent: Thursday, February 01, 2001 9:26 AM
Subject: RE: [jBoss-User] JAWS: How to deal with CHAR-columns and
trailingspaces
>
> --- Cor Hofman <[EMAIL PROTECTED]> skrev: > You could consider changing
the PK
> to be VARCHAR. Oracle will then
> > automatically
> > strip the trailing spaces.
> >
> Yes, but what if the table is huge, is in an already existing production
> environment, and changing the datatype could have side effects on
> existing applications?
>
>
> _____________________________________________________________
> Do You Yahoo!?
> Få din egen, gratis @yahoo.no-adresse på http://mail.yahoo.no
>
>
> --
> --------------------------------------------------------------
> To subscribe: [EMAIL PROTECTED]
> To unsubscribe: [EMAIL PROTECTED]
> List Help?: [EMAIL PROTECTED]
>
>
--
--------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
List Help?: [EMAIL PROTECTED]
