2013/3/11 Kevyn Bernard <[email protected]>: > The column is typed as VARCHAR.
> So I should change the collation to ANSI ? I think Ricardo meant quite the opposite. Can the character 'œ' be represented in ANSI? Basically, you must ensure that you try to store the character in a column using a character set where the character is present. And then your server and client must agree on the character set used for transfer. This latter point is handled automatically for many databases, but I don't know how MySQL handles it. /Oskar > > Le lundi 11 mars 2013 15:39:59 UTC+1, Ricardo Peres a écrit : >> >> Is the column typed as VARCHAR or as VARCHAR2? The later uses UNICODE, >> which is what you should be using, while the former uses ANSI. >> >> RP >> >> On Monday, March 11, 2013 11:08:09 AM UTC, Kevyn Bernard wrote: >>> >>> Hi, >>> >>> I'm experiencing a problem with the french character 'œ'. >>> It won't be inserted/updated in my MySql database. No exception is fired, >>> just the character is "deleted" => 'œuvre' inserted in database as 'uvre' >>> >>> I'm using NHibernate 2.1.2.4000. >>> MySql is configured as InnoDB, and collation is "utf8 - utf8_unicode_ci" >>> >>> I search for any issue relative to this one, but couldn't find any. >>> >>> Thanks for you help. >>> > -- > You received this message because you are subscribed to the Google Groups > "nhusers" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To post to this group, send email to [email protected]. > Visit this group at http://groups.google.com/group/nhusers?hl=en. > For more options, visit https://groups.google.com/groups/opt_out. > > -- You received this message because you are subscribed to the Google Groups "nhusers" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/nhusers?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
