Re: Changing data types in mysql!

2008-01-23 Thread Sebastian Mendel 

Lenin Lakshminarayanan schrieb:

Hello,

I was pulling data from one datasource [ oracle ] earlier which had a couple
of fields as integer. Now i am moving to a newer data source and the same
fields are now varchar's in the newer oracle database.

I am planning to change the data types of those fields from integer to
varchar's as am not doing any arithmetic with those fields. Does anyone see
any issues with this approach ? Will this break any of the existing
functionality when i move from INT to varchar's ?


it will require more space
sorting will change

--
Sebastian

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Changing data types in mysql!

2008-01-23 Thread Jerry Schwartz 
 -Original Message-
 From: Lenin Lakshminarayanan [mailto:[EMAIL PROTECTED]
 Sent: Tuesday, January 22, 2008 6:54 PM
 To: mysql@lists.mysql.com
 Subject: Changing data types in mysql!

 Hello,

 I was pulling data from one datasource [ oracle ] earlier which had a
 couple
 of fields as integer. Now i am moving to a newer data source and the
 same
 fields are now varchar's in the newer oracle database.

 I am planning to change the data types of those fields from integer to
 varchar's as am not doing any arithmetic with those fields. Does anyone
 see
 any issues with this approach ? Will this break any of the existing
 functionality when i move from INT to varchar's ?

 Thanks !
 Lakshmi
[JS] INT values do not have to be quoted. VARCHAR values need to be quoted
and escaped. This might break some of your queries.




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]