Re: how to convert varchar to long?

[Sven K�hler]

1)
create table test1(text varchar(255))
//
create table test2(text long)
//
insert into test1 values('test')
//
insert into test2 select text from test1
2)
create table test1(text long)
//
create table test2(text long)
//
insert into test1 values('test')
//
insert into test2 select text from test1
1) doesn't work, but 2) does!?
So this is really urgent.
I need to insert a varchar into a long column.
For me, assigning a varchar column to a long column is the same as 
assigning float(2) to float(4) but you may be so kind and explain the 
difference to me.

I need both cases to work, 1) and 2), because both cases occur in my 
program. You cannot convert long to varchar, and you cannot convert 
varchar to long. So what do you expect me to do?

--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]