Character set problems

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
JeffG
Forum Commoner
Posts: 35
Joined: Wed Jan 30, 2008 1:42 pm
Location: Newbury, UK

Character set problems

Post by JeffG »

I have a WAMP system. If I enter a £ sign in a text box (browser set to Western ISO 8859-1), when I view the MySQL record in a command window, the character is displayed as ú. If I change the character in the record to £, I see an œ character in the text box. If I change the browser to UTF-8, I get an undisplayed character in place of the œ. If I update while in UTF-8, it writes ┐¢ (two characters) to the database as viewed in the command window.

Obviously I have some character set incompatibility, but can you say what it is? :cry:
User avatar
JAB Creations
DevNet Resident
Posts: 2341
Joined: Thu Jan 13, 2005 6:44 pm
Location: Sarasota Florida
Contact:

Re: Character set problems

Post by JAB Creations »

I'm guessing you haven't set the collation for the column in your MySQL table to UTF-8. :wink:
JeffG
Forum Commoner
Posts: 35
Joined: Wed Jan 30, 2008 1:42 pm
Location: Newbury, UK

Re: Character set problems

Post by JeffG »

Thanks. I'll do some more reading around this.
Post Reply