Handling UTF-8 Data

[ashore]

Folks, in an application with subject requirement, I've set a MySQL
table collation definition as follows
-
TABLE `captions` DEFAULT CHARACTER SET utf8 COLLATE utf8_bin

With PHPMyAdmin I've tried to paste a value - specifically Unieważnić
- into one field in that table. But I get an error complaint of
Warning: #1366 Incorrect string value: '\xC5\xBCni\xC4\x87' for column
'repl' at row 1

Nothing I've seen shows up google-wise WRT PHPMyAdmin and utf8
specifically.

What points am I missing? Settings anyplace I need to look at?
Thanks for any info/urls here. AS

[Robert Gonzalez]

Have you tried interfacing with your database using a real MySQL tool, like SQLYog, Navicat or even MySQL Workbench just to see if the web front end is causing the issue?

--
This group is managed and maintained by the development staff at 360 PSG. An enterprise application development company utilizing open-source technologies for todays small-to-medium size businesses.

For information or project assistance please visit :
http://www.360psg.com

You received this message because you are subscribed to the Google Groups "Professional PHP Developers" group.
To post to this group, send email to Professi...@googlegroups.com
To unsubscribe from this group, send email to Professional-P...@googlegroups.com
For more options, visit this group at http://groups.google.com/group/Professional-PHP

[Gaurav Kumar]

Hey dude,

Do something as below-

Modify the column charset as following-

"utf8_general_ci"

This will resolve your problem. Also to get more specific error try using SQLYog.

Gaurav Kumar
http://www.UncleCode.Com