Unsupported charset: '"UTF-8"' when trying to add a new database connection. about db_explorer HOT 11 CLOSED

Hi @gaza3g ,

did you try to choose "UTF8" from encoding select box? It is situated under "UTF-8" .

It is because mysql2 connector accept "UTF8" and postgresql connector accept "UTF-8". Thats the reason why utf8 is there 2 times.

from db_explorer.

Hi @robinbortlik.

Gosh, I completely overlooked the fact that there is "UTF8" and "UTF-8" in the drop-down. I thought the default option was the correct one. It works now and I'm sorry to have wasted your time. Thanks.

from db_explorer.

I'm happy that it helped :)

Btw.. there is another project which can help you to explore your databases. It is called labrador and you can find it on http://chrismccord.github.com/labrador/

from db_explorer.

Thanks for the suggestion. Looking into it now.

from db_explorer.

I have tried UTF8 and ISO-8859-1 too, still having issue...

from db_explorer.

Same prob here :(

from db_explorer.

@quacos sorry, for late response, I missed your comment.
@leader80 did you try UTF8 or UTF-8. What db are you using?

from db_explorer.

I found the issue, is UTF8 has to be lowercase!

from db_explorer.

= f.input :encoding, :collection => (Encoding.name_list + ["utf8"] + ["UTF8"]).sort, :selected => @database_connection.encoding || "UTF-8"
in _form.html.haml

from db_explorer.

:) just discovered it. Can you please change it and try if it is working?

from db_explorer.

yes its fix issue.

from db_explorer.