Updating string fields with wider values

Hello there,

The following SQL statements result in the error message "Source string
data is too wide for the target field".

create table Person (
FullName char(20)
)

insert into Person (FullName)
values ('His most imperial highness and ruler of the left side of the
Galaxy, Porky the Pig')

I guess this is WAD however it doesn't match the behaviour of other DBs
like MySQL. Is it configurable perhaps?

Regards,

Lachlan

> I guess this is WAD however it doesn't match the behaviour of other
> DBs like MySQL. Is it configurable perhaps?

It is WAD, yes. Most DBs try to avoid losing data.

--


Eivind Bakkestuen [NDD]
Please, no email unless requested.
Search Borland and third-party newsgroups here: www.tamaracka.com

Good point. But it does mean that I have to manually trim data that may be
too long. MySQL trims it for you but I've since discovered Interbase
doesn't. Since I'm targeting all three DBs I guess I'd better get used to
it.

Regards,

Lachlan

On Sun, 25 Jan 2004 14:54:55 +1000, Eivind Bakkestuen [NDD]
<Ieivind.bakkestuenHATE@nexusdb.comSPAM> wrote:

>> I guess this is WAD however it doesn't match the behaviour of other
>> DBs like MySQL. Is it configurable perhaps?
>
> It is WAD, yes. Most DBs try to avoid losing data.
>

> MySQL trims it for you

Yeah, MySQL is lax about a few thing, which is both good and bad.