I've got a problem with charsets / locale settings - specifically symbols not showing correctly in files - especially £ and '.
They are either showing as ? or little black diamonds with ? in them.

I've set my LANG to be iso8859-15 in my i18n file and rebooted but that's not helped, don't know what else to do.

I thought to begin with the problem was with windows clients writing files to the box, but it's happening with linux clients and on local host too. I've noticed that when I edit a file in vi and put a £ sign in I actually get what appears to be a £ followed by a space, when I delete the the £ the space becomes a diamond with a ? in it when under the cursor.

Anyone know how I can resolve this?

Nick.

hi nick,


did you get this problem resolved? i am having a similar problem....


cheers


andy

Me too

If you know the solutions, please post to the forum.

All Loal Character shows ????? while mysql character set server is correct.

I'm really new in Linux so, please tell me HOW TO CHANGE SERVER CHARACTER SET TO "tis620". I don't know either what is the default character set with the first insallation.

Thanks & Best Regards

Hi Nick,

I had the same problem with spanish characters. I wanted to set my locale settings with "es_ES.ISO-8859-1" but editing i18n only changed the local variable LANG.

I solved it doing

export LC_ALL="es_ES.ISO-8859-1"

in my .bash_profile


I hope this help you