Character conversions?
Posted: Sat Oct 30, 2004 2:11 pm
I have two MySQL databases. One is local the other is on the server. When I submit special characters locally, they appear the same in the database. When I submit special characters on the server, they appear to be converted.
For example, let's take the name Øystein. Locally the name appears as Øystein if I look in the database. But on the server, in the database I see Øystein. Naturally in the forums when I view it after selecting it, I am seeing it as it should appear.
Is there a setting somewhere for MySQL that causes this conversion?
I ask mostly because we switched servers at one point and any special character such as the one above is now appearing odd until I convert it on the backend.
For example, let's take the name Øystein. Locally the name appears as Øystein if I look in the database. But on the server, in the database I see Øystein. Naturally in the forums when I view it after selecting it, I am seeing it as it should appear.
Is there a setting somewhere for MySQL that causes this conversion?
I ask mostly because we switched servers at one point and any special character such as the one above is now appearing odd until I convert it on the backend.