Re: charaters from geoname UTF8 table display as latin1 - how to correct this?
Posted by: Ivan Gutschy
Date: March 28, 2011 10:51AM

sorry still lost on this command.

When I query
SELECT HEX(city) - this is entire query
i get
#1054 - Unknown column "city" in "field list"

City is the name of my column with utf8 names.
If I enter city in quotes like SELECT HEX('city') i get what i presume is hexadecimal code for "city".

I ran queries from phpmyadmin after i have selected desired table...

Options: ReplyQuote

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.