Page 1 of 1

Character conversions?

Posted: Sat Oct 30, 2004 2:11 pm
by SBukoski
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.

Posted: Sat Oct 30, 2004 2:31 pm
by Weirdan
[google]site:dev.mysql.com charset[/google]