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 »
  • Installing CiviCRM »
  • Joomla! Installations (Moderator: Deepak Srivastava) »
  • Not possible to define a new Individual having an accent in his first name.
Pages: [1]

Author Topic: Not possible to define a new Individual having an accent in his first name.  (Read 4159 times)

jmrubio

  • Guest
Not possible to define a new Individual having an accent in his first name.
May 22, 2007, 01:38:59 pm
Hi,

I have a vanilla installation of Joomla and CiviCrm on a Windows XP, see below for the relases numbers. As soon as I try do define within the administrator console a New Individual with an accent (french é) in his first name (in my case it is rené lagrange), I get the following non-recoverable error page:

Sorry. A non-recoverable error has occurred.

Database Error Code: Data too long for column 'sort_name' at row 1, 1406

Return to CiviCRM menu.



Error Details:

Array
(
    [callback] => Array
        (
           
  • => CRM_Core_Error
  • [1] => handle
            )

        [\code] => -1
       
[message] => DB Error: unknown error
    [mode] => 16
    [debug_info] => INSERT INTO civicrm_contact (nick_name , domain_id , contact_type , do_not_email ,    do_not_phone , do_not_mail , external_identifier , sort_name , display_name , home_URL , preferred_communication_method , preferred_mail_format , do_not_trade , hash , source ) VALUES ( NULL ,  1 , 'Individual' ,  0 ,  0 ,  0 ,  NULL , 'lagrange, ren�' , 'ren� lagrange' ,  NULL , '' , 'Both' ,  0 , '88d9cb7d252d9bf5b802e5c64126965c' ,  NULL )  [nativecode=1406 ** Data too long for column 'sort_name' at row 1]
    [type] => DB_Error
    [user_info] => INSERT INTO civicrm_contact (nick_name , domain_id , contact_type , do_not_email , do_not_phone , do_not_mail , external_identifier , sort_name , display_name , home_URL , preferred_communication_method , preferred_mail_format , do_not_trade , hash , source ) VALUES ( NULL ,  1 , 'Individual' ,  0 ,  0 ,  0 ,  NULL , 'lagrange, ren�' , 'ren� lagrange' ,  NULL , '' , 'Both' ,  0 , '88d9cb7d252d9bf5b802e5c64126965c' ,  NULL )  [nativecode=1406 ** Data too long for column 'sort_name' at row 1]
    [to_string] => [db_error: message="DB Error: unknown error" code=-1 mode=callback callback=CRM_Core_Error::handle prefix="" info="INSERT INTO civicrm_contact (nick_name , domain_id , contact_type , do_not_email , do_not_phone , do_not_mail , external_identifier , sort_name , display_name , home_URL , preferred_communication_method , preferred_mail_format , do_not_trade , hash , source ) VALUES ( NULL ,  1 , 'Individual' ,  0 ,  0 ,  0 ,  NULL , 'lagrange, ren�' , 'ren� lagrange' ,  NULL , '' , 'Both' ,  0 , '88d9cb7d252d9bf5b802e5c64126965c' ,  NULL )  [nativecode=1406 ** Data too long for column 'sort_name' at row 1]"]
)



I have tested the creation of a user in Joomla with the same accent without problem. But within CiviCrm no way to do the same. I have also tested on the demo site of CiviCrm, both Drupal and Joomla:

1) On Drupal everything works fine.
2) On Joomla I get no error page but the accentuated letter is droped: "rené" is displayed as "ren"


System information:
Database Version: 5.0.22-community-max-nt
PHP Version: 5.2.1
Web Server: Apache/2.2.4 (Win32) DAV/2 mod_ssl/2.2.4 OpenSSL/0.9.8e mod_autoindex_color PHP/5.2.1
WebServer to PHP interface: apache2handler
Joomla! Version: Joomla! 1.0.12 Stable [ Sunfire ] 25 December 2006 01:00 UTC
User Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.0.11) Gecko/20070312 Firefox/1.5.0.11


I am a newbie with Joomla and CiviCrm, any help welcome.


Piotr Szotkowski

  • I live on this forum
  • *****
  • Posts: 1497
  • Karma: 57
Re: Not possible to define a new Individual having an accent in his first name.
May 22, 2007, 09:31:24 pm
CiviCRM works only with UTF-8 (which is the default in Drupal and will be the default in Joomla 1.5). There are some tutorials on the Net (and on the Joomla forums in particular) on how to run Joomla 1.0 with UTF-8:

http://www.google.com/search?q=Joomla%20%22UTF-8%22
http://www.google.com/search?q=%22UTF-8%22+site%3Aforum.joomla.org
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.

jmrubio

  • Guest
Re: Not possible to define a new Individual having an accent in his first name.
May 25, 2007, 04:08:08 pm
Hi,

Thanks for the info. Since I am at the begining of the full setup (new to CMS's and CiviCRM), I have switched to Drupal where it seems to work great.

Regards.

Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Installing CiviCRM »
  • Joomla! Installations (Moderator: Deepak Srivastava) »
  • Not possible to define a new Individual having an accent in his first name.

This forum was archived on 2017-11-26.