[support] Encoding problems (Ivan Sergio Borgonovo)

[Cog Rusty]

On Wed, Apr 30, 2008 at 6:30 PM, Joe Murray
<joe.murray at jmaconsulting.biz> wrote:
> My default Drupal installs end up having latin1 as the character type in the
>  MySQL tables, unlike CiviCRM default installs that end up with utf8 charset
>  and utf8_unicode_ci as the collation. Might want to look at that as one
>  possible issue.
>
>  Joe

I think this happens when the default character set of the database is
latin1 and some modules don't specify any character set when
installing tables. So, whenever I create a new Drupal database I
always go to phpMyAdmin-->Operations and make sure to set the
charset/collation of the database to utf8/utf8_general_ci.


>  > On Wed, 30 Apr 2008 11:05:24 +0100
>  > "Edward  Peters" <edward.peters at uk.iofc.org> wrote:
>  >
>  > > I have special characters that need to go in a node title and into
>  > > CCK fields, but by default they do not display correctly. Can
>  > > anyone point me towards a solution which allows Unicode characters
>  > > in titles and CCK fields? Many thanks for our help!
>  >
>  > I've no problems with unicode chars and I didn't do any special setup.
>  > FAPI did all the magic.
>  > Can it be a client side problem?
>  >
>  > BTW if you're dealing with MS stuff in any way consider that they
>  > call UTF-18 Unicode, while Drupals works great with UTF-8.
>  >
>  > --
>  > Ivan Sergio Borgonovo
>  > http://www.webthatworks.it
>
>  --
>  [ Drupal support list | http://lists.drupal.org/ ]
>