CODEWITHSUNDEEP
mysqlcharacter-encoding
steven
steven

Reputation: 4875

latin1_general_ci and charset ISO-8859-15

I try to store strings of charset ISO-8859-15 in MySQL fields with CHARACTER SET latin1 COLLATION latin1_general_ci.

It seems to be the case that both of them are not full compatible. I am not able to save a correct €-Sign.

Can anybody tell me the correct CHARACTER SET for ISO-8859-15?

Upvotes: 1

Views: 3571

Answers (1)

Rick James
Rick James

Reputation: 142198

According to Wikipedia, there are 8 differences between ISO-8859-1 and ISO-8859-15. The €-Sign is one of them. I see on my copy of 5.6 a latin1 (ISO-8859-1) CHARACTER SET, but no latin9 (ISO-8859-15).

It is possible to add your own character set and collation to MySQL, but that may be more than you want to tackle. There is a Worklog for adding it, but they need nudging to ever get it done.

Sorry. Can you live with latin1 or latin2 (which has at least the Euro)? Or, better yet, switch to utf8, which has all the characters, and a zillion more.

Upvotes: 2

Related Questions