exit44

I have the db set to "utf8_general_ci" and the page set to UTF-8. There are a bunch of options in the MySQL DB for UTF-8... like "utf8_general_ci", "utf8_bin", "utf8_chech_ci", etc... Not sure which to choose.

I'm using php/mysql and the circle 'r' character (®) looks like it is supposed to in the DB.... just like a registered trademark symbol. But, when I print it out to an HTML page I get the funny looking question mark character. I have used htmlentities() and html_entity_decode() to try to fix it but it doesn't seem to be working. Does anyone know how to fix this?

Very helpful article. Thank you for posting it for me.

I have a very general question about database design. What is the purpose of allowing a field to be set to a NULL value in a database field. I have been building for a while and have really never used this setting. I always just test the output before displaying to the browser and if the field is empty I treat it accordingly. What are the advantages of NULL over this or does it have other purposes? Thanks!

Hi There, I'm new to PHP Freaks and would like to say "hello" to everyone. I've been a PHP/MySQL developer for about 4 or 5 years now and am looking forward to learning and sharing information with all of you. Best regards, Joe