Re: [ADMIN] text & char(32)

2000-09-19 Thread bangh
If your define your table using varchar(32), instead of char(32), your query will work fine. -- banghe Herbert Ambos wrote: > On Tue, 19 Sep 2000, Vladimir V. Zolotych wrote: > > > Hi all, > > Can you help me a bit ? > > The question is: how can I compare TEXT and CHAR(32) types ? > > More d

Re: [ADMIN] text & char(32)

2000-09-19 Thread Karel Zak
On Tue, 19 Sep 2000, Vladimir V. Zolotych wrote: > Hi all, > Can you help me a bit ? > The question is: how can I compare TEXT and CHAR(32) types ? > More detailed description: > my=> create table foo (tt text, cc char(32)); > > CREATE > my=> insert into foo values ('aa', 'ab'); > >

Re: [ADMIN] text & char(32)

2000-09-19 Thread Herbert Ambos
On Tue, 19 Sep 2000, Vladimir V. Zolotych wrote: > Hi all, > Can you help me a bit ? > The question is: how can I compare TEXT and CHAR(32) types ? > More detailed description: > my=> create table foo (tt text, cc char(32)); > > CREATE > my=> insert into foo values ('aa', 'ab'); > > I

[ADMIN] text & char(32)

2000-09-19 Thread Vladimir V. Zolotych
Hi all, Can you help me a bit ? The question is: how can I compare TEXT and CHAR(32) types ? More detailed description: my=> create table foo (tt text, cc char(32)); CREATE my=> insert into foo values ('aa', 'ab'); INSERT 27476810 1 my=> insert into foo values ('aa', 'aa'); INSERT