Vizzuality/cartodb — Issue #384: UTF8 chars from SQL console are being incorrectly urlencoded
Author: tokumine
Created: 2011-12-07 21:43:54+00:00
State: open

(note - work on with @tokumine)

Looks like there's a bug in the way we url encode the sql before it's sent to the API from the SQL console in the UI

If you enter any non ASCII chars they are encoded incorrectly and trigger a 'invalid byte sequence in UTF-8.' error.

eg.

SELECT * FROM my_table WHERE name LIKE 'Montré%'

incorrectly becomes

SELECT * FROM my_table WHERE name LIKE 'Montr%E9'

You can see more on this bug here:

http://support.cartodb.com/discussions/problems/88-encoding-problem-in-sql-from-ui