SQL number format

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
mjseaden
Forum Contributor
Posts: 458
Joined: Wed Mar 17, 2004 5:49 am

SQL number format

Post by mjseaden »

Hi,

I'm using ADO to call an SQL query on a CSV file. I'm not sure what 'type' of SQL ADO uses, but I'm asking here because from past experience with PHP/MySQL, people here know what they're talking about.

I am extracting a long number, 19 digits long, and the field I get out is in 'scientific' number format, e.g. 1.23456E+17. I want the number straight, which means it might be better to extract it as a string rather than as a number. Is this possible?

Many thanks

Mark
Post Reply