• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 569
  • Last Modified:

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
0
topevents
Asked:
topevents
  • 3
  • 2
  • 2
  • +1
1 Solution
 
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
 
Richard QuadlingSenior Software DeverloperCommented:
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
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
fiboCommented:
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
 
fiboCommented:
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 DeverloperCommented:
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
 
Richard QuadlingSenior Software DeverloperCommented:
Thanks.
0

Featured Post

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

  • 3
  • 2
  • 2
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now