I am using a custom font on the website i'm developing and some basic characters are not being displayed. What seems to be the problem?
Also i am fetching the content from MYSQL.
Is the font bad?
@font-face {font-family: Cabin_Regular; src: url('fonts/Cabin_Regular.ttf');}
@font-face {font-family: Lobster; src: url('fonts/Lobster.ttf');}
body, select, input, textarea {font-family: 'Cabin_Regular';color:white;font-size: 16px;text-shadow: 0.1em 0.1em 0.2em black;}
h1, h2, h3, h4, h5, h6 {font-family: 'Lobster'; margin-bottom: 0;padding-bottom: 0;margin-top: 0; padding-top: 0;}
Check the encoding in your MySQL database. If it's not UTF-8 you're going to have issues
if it isn't UTF-8 use the following after you've connected to the database and are about to execute a Query
mysql_set_charset('utf8',$database_Connection);
Also make sure you have the charset defined in the <head>
of your html document
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
... I actually ran into this problem myself once when using a client's database which was set to Latin1. A real pain to figure out the first time.
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
what can i do? how do i change i - J.D 2012-04-04 01:39
ALTER TABLE tbl_name CONVERT TO CHARACTER SET utf8;
J.D 2012-04-04 01:52
mysql_set_charset('utf8',$database_Connection);
before you execute your query in the php (I assume its PHP?) - OAC Designs 2012-04-04 02:09
http://stackoverflow.com/a/6116205/109785 - OAC Designs 2012-04-04 02:27
First check if the characters are encoded for example the copyright symbol should be ©
in the database.
Second check if the font even supports the character some fonts don't have all of the glyphs you want. What are the characters suppose to be?
This is almost certainly an encoding issue. See http://ask.metafilter.com/mefi/28045 for some solutions.
To clarify, everything (PHP, MySQL, and even their conneciton to eachother) needs to be communicating in the same encoding or the same entities will be rendered differently. The standard is utf-8, but the important issue isn't really which is used but that it is used uniformly. There are good suggestions on how to get everything on the same page in the above link.
ENGINE=MyISAM DEFAULT CHARSET=latin1;
J.D 2012-04-04 01:40