How to make silently truncate for char type
| От | Terence Leung |
|---|---|
| Тема | How to make silently truncate for char type |
| Дата | |
| Msg-id | 20021208120154.10496.qmail@web40705.mail.yahoo.com обсуждение |
| Ответы |
Re: How to make silently truncate for char type
Re: How to make silently truncate for char type |
| Список | pgsql-general |
I upgraded postgresql 7.1 to 7.2 and found that many
sql cannot execute because version 7.2 does not
silently truncate the string for char(n) type during
insert a new row.
e.g. insert t (field1) value ('abcdef');
where field1 is char(5) but I insert the string
has 6 characters.
How can I solve the problem except downgrade the
Postgresql?
Looking forward to your reply!!!
=====
Yours sincerely,
Leung Chun Man, Terence
Mobile: (852) 9273 9176
Homepage: http://tcmleung.uhome.net ,
http://www.dynamicdrive.com/dynamicindex4/filter/index.htm
__________________________________________________
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com
В списке pgsql-general по дате отправления: