Re: [PHP-DB] ODBC avec PHP
You will have much better results if you use the odbtp extension instead of the odbc extenstion, especially on Linux. The odbtp_field_type() function will give you the correct type name. Also, you could use the mssql extension. However, mssql_field_type() returns type names that are not exact. For example, it returns char for all character fields even if their type is varchar, text, nchar, nvarchar or ntext. -- bob On Thu, 8 Jul 2004, Jean-François Léost wrote: hi I want to use the function odbc_field_type on a linux mandrake 10 with PHP 4.3.7 with unixODBC et freeTDS This function never give me a good answer : Example of an answer : Xÿ¿p [EMAIL PROTECTED] [EMAIL PROTECTED]@[EMAIL PROTECTED]@ Someone can help me ? Jeff -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] ODBC avec PHP
Hi Thanks for your answer but : What is odbtp extension I don't find it on www.php.net ??? I use ADOdb to database abstraction and I can't change all the ADOdb code. Do you know why the function odbc_field_type don't give me the good result ? Is is a PHP error, an unixODBC error or a freeTDS error ? To acces to MsSqlServer, which ODBC connection do you prefer ? thx to help me Jeff Robert Twitty [EMAIL PROTECTED] a écrit dans le message de news:[EMAIL PROTECTED] You will have much better results if you use the odbtp extension instead of the odbc extenstion, especially on Linux. The odbtp_field_type() function will give you the correct type name. Also, you could use the mssql extension. However, mssql_field_type() returns type names that are not exact. For example, it returns char for all character fields even if their type is varchar, text, nchar, nvarchar or ntext. -- bob On Thu, 8 Jul 2004, Jean-François Léost wrote: hi I want to use the function odbc_field_type on a linux mandrake 10 with PHP 4.3.7 with unixODBC et freeTDS This function never give me a good answer : Example of an answer : Xÿ¿p [EMAIL PROTECTED] [EMAIL PROTECTED]@[EMAIL PROTECTED]@ Someone can help me ? Jeff -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] ODBC avec PHP
The latest version of ADODb supports odbtp. You can get it at http://odbtp.sourceforge.net. There are 2 versions of the ADODb driver: odbtp and odbtp_unicode. The problem you are having is caused by the inability of the ODBC driver to provide what the desired information. The FreeTDS ODBC driver still needs some more work. The odbtp extension currently provides the most complete support for SQL Server 2000. -- bob On Thu, 8 Jul 2004, Jean-François Léost wrote: Hi Thanks for your answer but : What is odbtp extension I don't find it on www.php.net ??? I use ADOdb to database abstraction and I can't change all the ADOdb code. Do you know why the function odbc_field_type don't give me the good result ? Is is a PHP error, an unixODBC error or a freeTDS error ? To acces to MsSqlServer, which ODBC connection do you prefer ? thx to help me Jeff Robert Twitty [EMAIL PROTECTED] a écrit dans le message de news:[EMAIL PROTECTED] You will have much better results if you use the odbtp extension instead of the odbc extenstion, especially on Linux. The odbtp_field_type() function will give you the correct type name. Also, you could use the mssql extension. However, mssql_field_type() returns type names that are not exact. For example, it returns char for all character fields even if their type is varchar, text, nchar, nvarchar or ntext. -- bob On Thu, 8 Jul 2004, Jean-François Léost wrote: hi I want to use the function odbc_field_type on a linux mandrake 10 with PHP 4.3.7 with unixODBC et freeTDS This function never give me a good answer : Example of an answer : Xÿ¿p [EMAIL PROTECTED] [EMAIL PROTECTED]@[EMAIL PROTECTED]@ Someone can help me ? Jeff -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php