Re: varchar(10) to decimal

2005-05-18 Thread Michael Stassen
und up. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 18, 2005 10:00 AM To: Jerry Swanson Cc: mysql@lists.mysql.com Subject: Re: varchar(10) to decimal Hi, if varchar represents decimal(6,x) where x>2, it's truncated. Else, it&#

RE: varchar(10) to decimal

2005-05-18 Thread Gordon
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 18, 2005 10:00 AM To: Jerry Swanson Cc: mysql@lists.mysql.com Subject: Re: varchar(10) to decimal Hi, if varchar represents decimal(6,x) where x>2, it's truncated. Else, it's converted : mysql> create table dcml (a

Re: varchar(10) to decimal

2005-05-18 Thread mfatene
L PROTECTED]>: > decimal(6,2) > > On 5/18/05, Philippe Poelvoorde <[EMAIL PROTECTED]> wrote: > > Jerry Swanson wrote: > > > > > I need to change format from varchar(10) to decimal. > > > When I alter the table the data is trimmed. > > > > >

Re: varchar(10) to decimal

2005-05-18 Thread Jerry Swanson
decimal(6,2) On 5/18/05, Philippe Poelvoorde <[EMAIL PROTECTED]> wrote: > Jerry Swanson wrote: > > > I need to change format from varchar(10) to decimal. > > When I alter the table the data is trimmed. > > > > What I'm doing wrrong? > > > >

Re: varchar(10) to decimal

2005-05-18 Thread Philippe Poelvoorde
Jerry Swanson wrote: I need to change format from varchar(10) to decimal. When I alter the table the data is trimmed. What I'm doing wrrong? TH ALTER TABLE your_table MODIFY your_column double NOT NULL DEFAULT '0.0'; should normally work. What is the command you are doing and ha

Re: varchar(10) to decimal

2005-05-17 Thread mfatene
on <[EMAIL PROTECTED]>: > I need to change format from varchar(10) to decimal. > When I alter the table the data is trimmed. > > What I'm doing wrrong? > > TH > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe

varchar(10) to decimal

2005-05-17 Thread Jerry Swanson
I need to change format from varchar(10) to decimal. When I alter the table the data is trimmed. What I'm doing wrrong? TH -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]