Convert db encoding
Posted: Fri Nov 12, 2004 11:04 am
Hi again
I'm trying to convert my db encoding but it seems that the CONVERT function isn't working (or I can't handle it).
This is my SQL query:
And this is the error returned:
What am I doing wrong??
Thx in advance.
I'm trying to convert my db encoding but it seems that the CONVERT function isn't working (or I can't handle it).
This is my SQL query:
Code: Select all
SELECT CONVERT(`text` USING latin2) FROM `news`;Code: Select all
#1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'USING latin2) FROM `news` LIMIT 0, 30' at line 1Thx in advance.