> I have taken a Microsoft Access database and have basically copied the > structure of it and rebuilt it in MySQL, however, I have encountered > some problems with formatting of data. I need to ask what is the most > suitable field type to use to retain the content from Access field types > > The MS Access fields are: > > Currency (formatted to £ with two decimal places e.g. £10.00)
DECIMAL(nnn,2) You'll have to add your own signage ($,£, etc.) upon extraction. > > Currency (formatted to £#,##0.00;(£#,##0.00) > > Date/Time (with a Now() default) >From the manual: The DATETIME type is used when you need values that contain both date and time information. MySQL retrieves and displays DATETIME values in 'YYYY-MM-DD HH:MM:SS' format. The supported range is '1000-01-01 00:00:00' to '9999-12-31 23:59:59'. > > Yes/No enum() or set() > > Number (as a percentage) decimal() > > Number (with field size of Double and Decimal Places of 2) > decimal() > What would be the equivalent of the above for MySQL 5.1.35? If there > isn't an equivalent for some, how can I work around it considering > that the Access version of the database is already used in an ASP > website? > see: http://dev.mysql.com/doc/refman/5.1/en/data-types.html --Curtis -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
