How to convert from varbinary to char/varchar in mysql

by

Late answer…

You can use CAST or CONVERT thus

CAST(foo AS CHAR(100))
CONVERT(foo, CHAR(100))

Supported types (5.5) are:

BINARY[(N)]
CHAR[(N)]
DATE
DATETIME
DECIMAL[(M[,D])]
SIGNED [INTEGER]
TIME
UNSIGNED [INTEGER]

You can not cast to varchar directly.
There is an open MySQL bug from 2008 which no-one seems to care about and is damn annoying

More Related Contents:

  1. You can’t specify target table for update in FROM clause
  2. Generating a range of numbers in MySQL
  3. How to get next/previous record in MySQL?
  4. How do I make a row generator in MySQL?
  5. MySQL INSERT INTO table VALUES.. vs INSERT INTO table SET
  6. MySQL number of items within “in clause”
  7. Error 1046 No database Selected, how to resolve?
  8. What’s the difference between VARCHAR and CHAR?
  9. Alter a MySQL column to be AUTO_INCREMENT
  10. Is there something wrong with joins that don’t use the JOIN keyword in SQL or MySQL?
  11. MySQL ON DUPLICATE KEY UPDATE for multiple rows insert in single query
  12. is there a group_concat function in ms-access?
  13. single fixed table with multiple columns vs flexible abstract tables
  14. MySQL remove duplicates from big database quick
  15. mysql, iterate through column names
  16. How to delete from select in MySQL?
  17. How to delete Duplicates in MySQL table
  18. How to ORDER BY a SUM() in MySQL?
  19. mySQL Returning the top 5 of each category
  20. Selecting Random Rows in MySQL
  21. Use A Union Or A Join – What Is Faster [closed]
  22. Error: The used SELECT statements have a different number of columns
  23. MySQL – how to front pad zip code with “0”?
  24. Find the number of columns in a table
  25. Mysql, reshape data from long / tall to wide
  26. MySQL: Compare differences between two tables
  27. Mysql strip time component from datetime
  28. How do I start auto increment from a specific point?
  29. In SQL how do I get the maximum value for an integer?
  30. Get the first and last date of next month in MySQL

Leave a Comment