We just have this in our database.yml file (in Rails) and it uses UTF-8 
correctly.

    encoding: UTF-8

Is it possible DataMapper.setup is being called somewhere else?  What 
environment (framework) are you in?


On 16/11/2011, at 2:32 PM, eggman2001 wrote:

> Hello,
> 
> I have the setup variable as follows (I've also tried "utf8" instead
> of "UTF-8")
> DataMapper.setup(:default, "mysql://root:password@localhost/sampledb?
> encoding=UTF-8")
> 
> Then after I run DataMapper.auto_migrate!, I see the following in my
> mysql log:
> 
>                   9 Query     SET sql_auto_is_null = 0
>                   9 Query     SHOW VARIABLES LIKE 'character_set_connection'
>                   9 Query     SHOW VARIABLES LIKE 'collation_connection'
>                   8 Query     CREATE TABLE `tests` (`id` INT(10) UNSIGNED NOT 
> NULL
> AUTO_INCREMENT, `title` VARCHAR(100), PRIMARY KEY(`id`)) ENGINE =
> InnoDB CHARACTER SET latin1 COLLATE latin1_swedish_ci
> 
> Notice that the character set is set to "latin1." Anyone know what
> could be causing this to not behave as I'm expecting?
> 
> -- 
> You received this message because you are subscribed to the Google Groups 
> "DataMapper" group.
> To post to this group, send email to [email protected].
> To unsubscribe from this group, send email to 
> [email protected].
> For more options, visit this group at 
> http://groups.google.com/group/datamapper?hl=en.
> 

-- 
You received this message because you are subscribed to the Google Groups 
"DataMapper" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to 
[email protected].
For more options, visit this group at 
http://groups.google.com/group/datamapper?hl=en.

Reply via email to