CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site
This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM (Moderator: Dave Greenberg) »
  • Accent marks
Pages: [1]

Author Topic: Accent marks  (Read 9239 times)

ekiczek

  • I’m new here
  • *
  • Posts: 2
  • Karma: 0
Accent marks
April 30, 2007, 01:38:01 pm
Hi everyone,

I have a contribution page profile which asks for name, among other
things. I have a report from a user who says that he couldn't enter the
accent marks on his name.

Are names with accent marks supported in CiviCRM? I'm using v1.7-rev
9172 on Drupal 4.7.

Thanks in advance,

Ethan

Michał Mach

  • Ask me questions
  • ****
  • Posts: 748
  • Karma: 59
    • CiviCRM site
  • CiviCRM version: latest
  • CMS version: Drupal and Joomla latest
  • MySQL version: numerous
  • PHP version: 5.3 and 5.2
Re: Accent marks
April 30, 2007, 01:45:08 pm
Ethan,

CiviCRM runs on UTF8, so letters with accents shouldn't be a problem. What are specific symptoms of not being able to enter the accent marks? Does CiviCRM throw an error and if it does, what's the error?

Just to let you know, I'm using vanilla CiviCRM installs with extended non-ASCII characters without any problems.  I also wonder what kind of accented letter is that - French? Spanish? German? It shouldn't make a difference, but if you can at least find out what's that, it might be easier to test.

Thx,
m
Found this reply helpful? Contribute NOW and help us improve CiviCRM with the Make it Happen! initiative.

My absolute favourite: Wordpress Integration!.

Donate Now!

marlutin

  • I’m new here
  • *
  • Posts: 22
  • Karma: 1
Re: Accent marks
June 01, 2007, 06:31:14 am
Hello, everybody

I have the same problem after installing civicrm 1.7 on a Joomla! 1.0.12 install (core in french). This occurs to any field from the adminsitrative contact to any contact name or content with (in my case) french characters éèà etc. The articles in Jooméla are handled correctly.
I tried with no succes the following:

CiviCRM  » Administer CiviCRM  Language Settings: Legacy encodings: set to "" or "Windows-1252" (no effect)

civicrm.settings.php, CIVICRM_GETTEXT_CODESET is set to utf-8 by installer

could anyone help?

Piotr Szotkowski

  • I live on this forum
  • *****
  • Posts: 1497
  • Karma: 57
Re: Accent marks
June 01, 2007, 06:50:33 am
Quote from: marlutin on June 01, 2007, 06:31:14 am
I have the same problem after installing civicrm 1.7 on a Joomla! 1.0.12 install (core in french). This occurs to any field from the adminsitrative contact to any contact name or content with (in my case) french characters éèà etc. The articles in Jooméla are handled correctly.

It’s because your site runs with the ISO-8859-1 encoding, while CiviCRM runs with the UTF-8 encoding.

Quote from: marlutin on June 01, 2007, 06:31:14 am
I tried with no succes the following:

CiviCRM  » Administer CiviCRM  Language Settings: Legacy encodings: set to "" or "Windows-1252" (no effect)

This only affects the CSV files for importing.

Quote from: marlutin on June 01, 2007, 06:31:14 am
civicrm.settings.php, CIVICRM_GETTEXT_CODESET is set to utf-8 by installer

This also doesn’t affect the encoding of the content.

Basically, the only sane way is to upgrade your Joomla install to use UTF-8. There are some tutorials on how to do it on both the joomla.org site and elsewhere.
If you found the above helpful, please consider helping us in return – you can even steer CiviCRM’s future and help us extend CiviCRM in ways useful to you.

marlutin

  • I’m new here
  • *
  • Posts: 22
  • Karma: 1
Re: Accent marks
June 01, 2007, 12:52:42 pm
Thanks for your suggestion. I will re-install Joomla with UTF-8 or restart the project with Drupal.
(message edited...) Hmmm. your suggestion is very useful, it worked and denotes that Joomla install for 1.0x is iso- and not utf-8. Specially the uncommented line in /includes/database.php was useful

@mysql_query("SET NAMES 'utf8'", $this->_resource); 

a db-dump, search/replace all iso-nnn to utf8 and db-import back, fixed it all

upgrading Jomla to utf-8 seems easy reading http://forum.joomla.org/index.php?topic=55065.0;wap2

Civicrm seems to share the Joomla db connection, Joomla stores in iso-nnn. it's maybe why this Joomla-side problem appears with Civicrm true utf-8 data storage. But i'm just a newbie with all that stuff-

But now I have to change all the localized texts file to some utf-8 encoding too... Hmmm. I thought Joomla was a recent code! Why french joomla site delivers a half-way utf-8 implementation? no idea.

Moved from my own dev's to that... I hope next versions will be more consistent... a multi-file search reveald  1'301 instance of "iso-8859-1", so thank you for your wise direction, but I'm sure to face many more surprises with text encoding! :-\
« Last Edit: June 01, 2007, 02:20:11 pm by marlutin »

Piotr Szotkowski

  • I live on this forum
  • *****
  • Posts: 1497
  • Karma: 57
Re: Accent marks
June 02, 2007, 03:52:29 am
Quote from: marlutin on June 01, 2007, 12:52:42 pm
But now I have to change all the localized texts file to some utf-8 encoding too... Hmmm.

I don’t know about French, but when I last checked, the Polish localisation files were provided in two versions, ISO-8859-2 and UTF-8. Maybe you can find an UTF-8 French localisation file and use that?

Quote from: marlutin on June 01, 2007, 12:52:42 pm
I thought Joomla was a recent code!

Well, Joomla was supposed to use UTF-8 by default all the way back when the ‘next’ version was numbered 1.1 and scheduled for late 2005. Since then, the ‘next’ version got renumbered to 1.5 (and didn’t get released yet), but it will use UTF-8 by default.
If you found the above helpful, please consider helping us in return – you can even steer CiviCRM’s future and help us extend CiviCRM in ways useful to you.

mixxmedia

  • Guest
Re: Accent marks
September 01, 2007, 06:54:42 pm
I go lost in the thread... so can civicrm 1.7 with joomla 1.0.12 front-end save accented characters? I have the problem when entering French accents, they then display as ? for é etc.

Thanks

mxm

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Accent marks
September 02, 2007, 12:32:11 am

Joomla 1.0.x is not utf8 friendly. You will need to hack joomla to make this happen. Might want to check on the joomla forums.

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

mixxmedia

  • Guest
Re: Accent marks
September 03, 2007, 08:30:26 am
Thanks again lobo

mxm
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM (Moderator: Dave Greenberg) »
  • Accent marks

This forum was archived on 2017-11-26.