Charset Changing: Difference between revisions

no edit summary
No edit summary
No edit summary
Line 7: Line 7:


==MySQL==
==MySQL==
* 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>
# 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, '''before''' the line above: <pre><nowiki>character-set-server = cp1250  
collation-server = cp1250_general_ci</nowiki></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
character set database cp1250 cp1250
character set database cp1250 cp1250