Strange character displaying for BIT field

Archives Yii 1.0.x Discussions
1

Hi friends.  I'm storing a few fields in MySQL as a bit(1) data type.  I am storing either a 0 or 1 for true or false.  When Yii retrieves the value… it's displaying as �

is the browser - yes … a black diamond with a ? mark in the middle of it.

Does anyone know why this is happening?

2

Most likely you are setting a default language charset in your web server config.  Usually you should leave it unset so the server will use the default.

EDIT: To clarify, the web browser doesn't understand the character it's supposed to display so it replaced it with the black diamond question mark.

3

I haven't changed any settings like that.  Where would I look for something like that?

4

In my apache http.conf, here's the line I use:

AddDefaultCharset UTF-8

You can try adding/uncommenting that and see if it makes a difference.

5

Okay that doesn't change anything … but it looks like it's displaying this for true:

and this for false:

�

Hmmmmmm.  That's strange.  I am looking in the MySQL DB and it's clearly stored as 1 and 0.

6

Well it must have been something with the BIT datatype… maybe they behave differently in MySQL and SQL Server.  I changed it to a TINYINT and it works just fine.

7

sweet :)