Character conversions?

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
SBukoski
Forum Contributor
Posts: 128
Joined: Wed May 21, 2003 10:39 pm
Location: Worcester, MA

Character conversions?

Post 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.
User avatar
Weirdan
Moderator
Posts: 5978
Joined: Mon Nov 03, 2003 6:13 pm
Location: Odessa, Ukraine

Post by Weirdan »

[google]site:dev.mysql.com charset[/google]
Post Reply