How did you build/install PHP? 
Make sure you don't have any old libmysqlclient.so in your system.

Thank you for your reply.

I've checked libmysqlclient.so in system, and I find libmysqlclient.so point to libmysqlclient.so.15.0.0

I installed PHP by using rpm packages at 

http://ftp.opensuse.org/pub/opensuse/repositories/server:/php/server_apache_SuSE_Linux_10.0/i586/

Assigned to MySQL people.

Well.. I myself create those packages are u  using, so next time drop me a note if you found any problem with them.

this bug is likely to be bogus.


user says he is running mysql 5.0.24 but SUSE 10.0 do not include mysql5, nor server_apache_SuSE_Linux_10 repository packages are linked against mysql 5 client libraries.

Thank Tony very much for your cares.

Thank judas very much for your comment. However, this problem (perhaps it's not a bug) is real. You can install Apache5-2.2.3, then install PHP5-5.1.6 (from the link in my last reply), and install MySQL 5.0.24 for SuSE 10.0 (what you said it's not included in SuSE 10.0) from this link:

http://ftp.opensuse.org/pub/opensuse/repositories/server:/database/SUSE_Linux_10.0/i586/

(Maybe this link is so long, it can be broken into 2 lines, please fix/merge these 2 lines before you check up)

Thank everyone.

Regards,
Albert Brian.

At the ending, I hope someone can help me fix "Unable to load dynamic library
'/usr/lib/php5/extensions/mysqli.so'" in first my comment.

to be more precise, they are linked against mysql 4.1.13 libraries, because that is the mysql version the distribution contains, and what you are supposed to be using if you choose the server_apache_SuSE_Linux_10.0 repository.

and no, there is currenlty no php version for 10.0 linked against mysql 5, only for 10.1.

Thank Judas.

My bad, I do not really understand meaning of "what
you are supposed to be using if you choose the
server_apache_SuSE_Linux_10.0 repository". Can you please make it more clear ? Thanks.

Currently, I temporarily uninstall mysqli extension.

Temporarily close this to do more investigation.

Please leave the status as it is, I'd like MySQL people to take a look at it.
The question is why mysql_set_character_set() is not exported in libmysqlclient.so, while it's expected to be.

mysql_set_character_set is a symbol defined in all MySQL 4.1 and 5.0 client libraries on my system (and i have quite a few). It is nothing that is only conditionally compiled in either (afaict.)

My educated guess on this would be: some other apache module uses an older (<= 4.0) mysql client library?

What happens if you try to run the PHP CLI binary and try to load ext/mysqli into that?

Okay I think I've figured out a clue to solve this problem.

a) For MySQL 5.0.x: libmysqlclient.so.15 is required
b) For PHP 5.1.x rpm package (OSS 10.0) was compiled to "decide" by itself: libmysqlclient.so.14 "has to" be used

From MySQL.Com, you can download "Shared compatibility libraries (4.x, 5.x libs in same package)" which contains many version of libmysqlclient.so. Think of it, if MySQL 5.0.x use libmysqlclient.so.15 but PHP 5.1.x was compiled to request libmysqlclient.so.14 only, it would make many troubles.

My English is not very well, I hope everyone could understand what I mean.

To solve this, just re-compile PHP 5.1.x rpm package (which is for OSS 10.0) to use libmysqlclient.so.15, or use the version as same as MySQL (in case users can choose diff MySQL version)

Not a PHP problem. Don't mix different versions.