search

vieten / sequel-pro

Automatically exported from code.google.com/p/sequel-pro
Other
0 stars 0 forks source link

Sequel Pro treats latin1 as ISO-8859-1, MySQL as cp1252 #1208

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago 
At least, I think it does. And that's wrong because what MySQL considers latin1 
is really cp1252 according to this page:

http://dev.mysql.com/doc/refman/5.0/en/charset-we-sets.html

What steps will reproduce the problem?
1. select convert(char(0x80) using latin1);

What is the expected output? What do you see instead?

I expect to see the Euro character (€), instead I see nothing.

Using SP 0.9.9.1 (3408) and MySQL 5.1.31.

Original issue reported on code.google.com by j.rademaker on 11 Oct 2011 at 8:10

GoogleCodeExporter commented 9 years ago 
Yes, Sequel Pro uses ISO-8859-1 whereas MySQL uses cp1252.

Original comment by schlabbe...@gmail.com on 11 Oct 2011 at 2:13