> -----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]