Hello,

I must modify an application build with MySQL to make it work with other databases.

This application works perfectly but use quotes in all the requests even for numeric columns.

For example:
SELECT * FROM table WHERE id='1'

(where id is declared as INTEGER)

Do you know if this syntax is accepted by all databases?

I think most DBs would know to parse it as an int (I know mysql and mssql will). If you're working in PHP, using PDO might simplify the process of making your application more portable:

http://www.google.com/search?hl=en&q...earch&aq=f&oq=

Using your example with PDO:

PHP Code:

$id = 1;

$db = new PDO();
$stmt = $db->prepare('SELECT * FROM table WHERE id=?');
$stmt->bindParam(1, $id);
$stmt->execute(); 


In the example above you don't have to worry about quotes, even for strings.

Thank for your answer, so I can add MSSQL to my list of compatibles databases. At this time MySQL, Oracle, MSSQL, PostgreSQL and SQLite seem to be compatible.

Yes I plan on using PDO

Unfortunately due to the structure of the application (and many generated requests) I will not be able to use prepare() all the time. The code is not really compatible with this new approach that comes with PDO.

I will be able to support only the databases compatible with this syntax, the more they are, the best it is for me in this case.

Other compatible databases??