Charset Changing: Difference between revisions
No edit summary |
m Reverted edits by Upazixorys (Talk); changed back to last version by Olajideolaolorun |
||
| (10 intermediate revisions by 5 users not shown) | |||
| Line 1: | Line 1: | ||
This wiki article will help you change your | This wiki article will help you change your <u>Char</u>acter <u>Set</u> to something else other than the default Uniform Server setting (ISO-8859-1 / latin1). | ||
In this article, our goal is to set the charset to '''cp1250''' | In this article, our goal is to set the charset to '''cp1250''' | ||
==Apache== | ==Apache== | ||
Find this statement in the Apache configuration file (W:/usr/local/apache2/conf/httpd.conf) <pre>AddDefaultCharset iso-8859-1</pre> and change it to: <pre>AddDefaultCharset WINDOWS-1250 | |||
AddCharset WINDOWS-1250 .cp-1250 .win-1250</pre> ''Note: See ftp://ftp.isi.edu/in-notes/iana/assignments/character-sets for the official list of charset names and their respective RFCs.'' | |||
==MySQL== | ==MySQL== | ||
# In the file (W:/ | # In the file (W:/usr/local/mysql/bin/my_small.cnf) find line: <pre>Uncomment the following if you are NOT using BDB tables</pre> | ||
# Insert the two following lines, '''before''' the line above: <pre><nowiki>character-set-server = cp1250 | |||
# Insert the two following lines: <pre> | collation-server = cp1250_general_ci</nowiki></pre> | ||
# Restart Apache and MySQL and verify that system variables looks like this: <pre><nowiki>character set client latin1 cp1250 | # Restart Apache and MySQL and verify that system variables looks like this: <pre><nowiki>character set client latin1 cp1250 | ||
character set connection cp1250 cp1250 | character set connection cp1250 cp1250 | ||
| Line 32: | Line 32: | ||
If you have a PHP definition or configuration file, the file where global interraction with MySQL is set, (look for a filename like: definition.php, cofig.php, etc.) in the "appropriate" place (you have to find the place yourself,) insert two lines of code: <pre>mysql_query("SET character_set_connection=cp1250"); | If you have a PHP definition or configuration file, the file where global interraction with MySQL is set, (look for a filename like: definition.php, cofig.php, etc.) in the "appropriate" place (you have to find the place yourself,) insert two lines of code: <pre>mysql_query("SET character_set_connection=cp1250"); | ||
mysql_query("SET character_set_client=cp1250");</pre> | mysql_query("SET character_set_client=cp1250");</pre> | ||
[[Category: Installation]] | |||
[[Category: User Made]] | |||
[[Category: Self Install]] | |||
[[Category: Development]] | |||