About You have arrived at this page because InsideRIA is no longer an active website, as of January 31, 2011. While we're sad to see the change, we think you will find the resources and community here at oreilly.com helpful. An archive of the material previously posted on InsideRIA can be found at DevelopRIA.com .
November 21, 2008 at 9:31 am Drew Massey So, as some of you know, I’ve been working on inventoriana.com for a while now. In its new iteration, I am trying to shake of some of the problems of the existing version – one of the most important of which is allowing images of arbitrary size to be displayed and navigated easily. Taking a page from the playbook of the Center for Hellenic Studies , I’ve been playing with Google Maps. They have a nice, easy to use interface, and the added luxury of playing well with ActionScript 3.0 and Flash (which much of inventoriana is currently implemented in). So this is a little bit of documentation for anyone who wants to just render images in flash using the Google Maps API.
I found out the problem with the uft8 problem (I had the same problem, see some posts above). You must add the "CHARACTER SET utf8" into the LOAD DATA command. # open mysql command line mysql --default-character-set=utf8 -u root -p # set character-set to utf8 SET NAMES 'utf8'; # create the database CREATE DATABASE `geonames`; # use the database USE `geonames`; # create the allCountries table for example CREATE TABLE `geonames`.