CODEWITHSUNDEEP
phpmysqlcharacter-encodingspecial-characters
HGPB
HGPB

Reputation: 4366

Certain characters failing to be inserted into database

I have multi language characters that are being inserted into a varchar column of a MySQL MyISAM table.

One particular character, and I'm sure there are others is failing to be inserted:

�

What is this character and how can I convert this character without affecting the entire word. The server side code that can be used to manipulate these words is php.

Examples of actual words including this symbol are as follows:

portugu�s

espa�a

etc

What is the best way to insert these words correctly?

Upvotes: 0

Views: 164

Answers (1)

James C
James C

Reputation: 14149

Getting charactset issues right can be a bit of a mission. Have a look at this blog post I wrote a couple of weeks ago which should cover this off. Post back here if you're still having problems.

How to Avoid Character Encoding Problems in PHP

Upvotes: 1

Related Questions