That’s unnecessary. Just use SELECT CONVERT(column USING utf8) FROM
….. instead of just SELECT column FROM
…
More Related Contents:
- MySQL Insert query doesn’t work with WHERE clause
- Delete from two tables in one query
- Why would an IN condition be slower than “=” in sql?
- PostgreSQL GROUP BY different from MySQL?
- GROUP BY behavior when no aggregate functions are present in the SELECT clause
- Fulltext Search with InnoDB
- MySQL dump by query
- MySQL’s now() +1 day
- Delete sql rows where IDs do not have a match from another table
- Rewriting mysql select to reduce time and writing tmp to disk
- In SQL / MySQL, what is the difference between “ON” and “WHERE” in a join statement?
- MySQL – Selecting data from multiple tables all with same structure but different data
- What does DELIMITER // do in a Trigger?
- Does Mysql have an equivalent to @@ROWCOUNT like in mssql?
- MySQL equivalent of DECODE function in Oracle
- How do you version your database schema? [closed]
- MySQL, Get users rank
- Mysql: how to select groups having certain values?
- How to fill date gaps in MySQL?
- Adding a new SQL column with a default value
- Boolean vs tinyint(1) for boolean values in MySQL
- Selecting all corresponding fields using MAX and GROUP BY
- MySQL full text search for words with three or less letters
- MySQL: “The SELECT would examine more than MAX_JOIN_SIZE rows”
- Function for week of the month in mysql
- MySQL’s alternative to T-SQL’s WITH TIES
- Find rows that have the same value on a column in MySQL
- what is the difference between GROUP BY and ORDER BY in sql
- How to transform vertical data into horizontal data with SQL?
- How do MySQL views work?