Problem in type convertion

Brought to you by: dcech, jburns131, richtl

Problem in type convertion

Forum: Open Discussion

Creator: Geoffroy

Created: 2005-04-06

Updated: 2013-04-01

Geoffroy - 2005-04-06

Hello

I use Adodb and Axmls to export my MySQL database to Oracle.
Type transformation occurs in converting to Metatype :

origine : MySQL type : decimal(10,2)

->MySQL type converted to MetaType : type= 'N ' size='10'
I loose ',2'

->MetaType converted to Oracle type : DECIMAL(10)

so I have a transformation from decimal(10,2) to decimal(10)

Is someone able to explain me how to stop this ?

Thanks

Geoffroy

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
- Geoffroy - 2005-05-24
  
  This is solved for my project... If you have this problem : see in adodb.inc.php :
  
  ADOFieldObject->max_length
  ADOFieldObject->scale
  
  ADOFieldObject->scale is not used so no decimal values !!!
  
  If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
- Geoffroy - 2005-05-24
  
  This is solved for my project... If you have this problem : see in adodb.inc.php :
  
  ADOFieldObject->max_length
  ADOFieldObject->scale
  
  ADOFieldObject->scale is not used so no decimal values !!!
  
  -----------
  Geoffroy
  
  If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Log in to post a comment.