character problem - euro sign

I'm currently using MySQL 4.1.18 and phpMyAdmin 2.8.0.2, but I'm having troubles with the character sets...

I'm currenly using UTF-8 Unicode (utf8) with connection collation utf8_general_ci on database, tabel and column level. Everything goes fine when inserting text using a text field in a script, but when I insert a row using phpMyAdmin things go wrong with the euro character. In phpMyAdmin it is displayed correctly, but it isn't on my website... Does anybody knows what the problem could be?

Would it be better to use a different character set for Belgium? Latin1? But with wich collation set latin1_bin, latin1_general_cs, latin1_general_ci,...?

Kevin
topeventsAsked:
Who is Participating?
 
Richard QuadlingSenior Software DeveloperCommented:
As more and more people get online who do NOT use the Latin1 character set, we are all going to have to go unicode. That will be the only way we can guarantee that the symbol entered as (made up) #805f; remains that way all the way through from client to db and to other clients.

0
 
Muhammad WasifCommented:
>>>In phpMyAdmin it is displayed correctly, but it isn't on my website

Did you set the web page encoding to utf-8?
0
 
topeventsAuthor Commented:
I the mean time I found the problem myself... There was a configuration problem in phpmyadmin causing this problem. I solved it and changed all character sets to latin1.
0
Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

 
Richard QuadlingSenior Software DeveloperCommented:
Be careful. What is sent to the browser to represent the euro symbol. What font are you using? Does that font have a Euro symbol in it?

Ah. Just then read you solved it.
0
 
Bernard S.CTOCommented:
You should consider sticking with UTF8. Later, you'll be glad you did.
If I understand well, the only problem is when making data entry thru phpMyAdmin facility.
- Which version of phpmyadmin are you using?
- do you still have the problem with the € if, instead of typing it from keyboard, you paste it from some other source?
0
 
topeventsAuthor Commented:
Why sticking to uft8? In the mean time I changed everyting to Latin1 and now at last 'everything' is working like it has to be...
0
 
Bernard S.CTOCommented:
Sticking with utf-8 almost guarantees that your site will be able to handle almost all situations. Like
- displaying or sending RSS feeds with feedburner
- correctly display whichever accentedcharaxters might pass by
etc.
If later you need to convert your data, you will NOT appreciate
0
 
Richard QuadlingSenior Software DeveloperCommented:
Thanks.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.