Set character set?
I am having problems with my character set - and as a result, certain characters get converted. I changed the column collation to "utf8_general_ci", but it didn't work.
When I use phpMyAdmin to edit the field, it updates properly, but when done from PHP it doesn't work (but if I echo the value right before insert, it shows up properly)
What do I need to do? I was told I need to change 'character_set_client', but I don't even know where/how to edit it.
Any assistance?
SonicMailer Pro - Professional mailing list manager & award-winning email marketing software
Download a FREE 30-day trial today!
Use coupon savemoreon4 and save 10%!
Abhishek Reddy posted this at 10:35 — 30th November 2006.
He has: 3,348 posts
Joined: Jul 2001
It's a MySQL variable (not phpMyAdmin or anything). The MySQL page on character sets and collations explains how to set the character_set_client variable, and other details. Execute a SQL statement like: [incode]SET character_set_client = x;[/incode] or equivalent -- you can do this from phpMyAdmin.
Post back if you still have problems. A more detailed description might help too.
Want to join the discussion? Create an account or log in if you already have one. Joining is fast, free and painless! We’ll even whisk you back here when you’ve finished.