Welcome to WebmasterWorld Guest from 220.127.116.11
I'm getting the following error notice in phMyAdmin:
"The mbstring PHP extension was not found and you seem to be using multibyte charset. Without mbstring extension phpMyAdmin is unable to split strings correctly and it may result in unexpected results."
This is an install on a Win2003 Server, my first on a machine with "asian languages" enabled, otherwise i've had many succesful php/mysql install on win2003.
My question is, if I have no intention of storing content in any asian languages on this server, should I still install the mbstring extension? Does the extension degrade performance or increases database size in anyway?
Otherwise, it should not affect anything unless you actually use the multi-byte functions. If you don't, the text will still be stored using the ISO-8859-1 character set just like always. No effect on database size whatsoever.
Whether or not the DB only has western characters in it and whether or not you have multi-byte enabled in PHP are two completely separate issues. Essentially, it is a specific case of asking whether or not having PHP installed will affect the size of your MySQL database. Answer: it all depends on what your are doing with PHP. If PHP is not your means of interacting with the DB (e.g. you access it through Perl), then PHP has no effect whatsoever on the size of your DB. On the other hand, if you write a PHP script that is supposed to access the DB, you had best have PHP installed. Other than at server startup, having PHP installed won't really negatively affect the performance of you server.
Similarly, if you have the multi-byte extensions enabled, this in and of itself has no effect whatsoever on your data and your database unless you use them to input characters that are not part of the ISO-8859-1 character set. In that case, it would be better to do it in a manner that is correct and have the MB extensions installed.
I don't really see a downside to having MB enabled except that it will take a couple of microseconds longer for the server to start up. I'm not sure, but I don't think it will even affect memory usage unless you actually invoke the mb_* functions, since I believe the MB module is not loaded until needed.
This is also not a western/non-western issue. I have nothing but western characters in any database, but because many western punctuation marks lie outside the ISO-8859-1 set, sometimes the multi-byte extensions come in handy.