topevents
asked on
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
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
ASKER
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.
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.
Ah. Just then read you solved it.
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?
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?
ASKER
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...
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
- 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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Thanks.
Did you set the web page encoding to utf-8?