Results 1 to 3 of 3
Like Tree1Likes
  • 1 Post By christianknoll

Thread: set sugarcrm a connection string to database with parameters

  1. #1
    rodnikosh Guest

    Default set sugarcrm a connection string to database with parameters

    my SugarCRM uses a database named "sugarcrmheb" (mysql).
    i want sugarcrm to connect to this database using this connection string with parameters:

    192.168.x.x/sugarcrmheb?useUnicode=true&characterEncoding=UTF-8

    where can i add those parameters so that sugarcrm will connect to the database with those parameters.
    my config.php file has these configurations:

    'dbconfig' =>
    array (
    'db_host_name' => 'localhost',
    'db_host_instance' => 'SQLEXPRESS',
    'db_user_name' => 'xxxxxxxx',
    'db_password' => 'xxxxxxx',
    'db_name' => 'sugarcrmheb',
    'db_type' => 'mysql',
    'db_port' => '',
    'db_manager' => 'MysqliManager',
    ),

    do i put the parameters here somewhere?

    (i think i need to add these parameters so reports with hebrew characters (utf-8) in them will work - they don't work right now)

  2. #2
    christianknoll's Avatar
    christianknoll is offline Sugar Community Member
    Join Date
    Nov 2008
    Location
    Vienna
    Posts
    1,382

    Default Re: set sugarcrm a connection string to database with parameters

    SugarCRM works out of the box with UTF8 and Unicode ... there should be no need to add those characters. We have multiple clients in Unicode settings and never had any issues.

    However if you need to add the parameters I assue you need to do it right in the databasee layer (include/database/MysqliManager.php) in the function connect.

    christian.

    Quote Originally Posted by rodnikosh View Post
    my SugarCRM uses a database named "sugarcrmheb" (mysql).
    i want sugarcrm to connect to this database using this connection string with parameters:

    192.168.x.x/sugarcrmheb?useUnicode=true&characterEncoding=UTF-8

    where can i add those parameters so that sugarcrm will connect to the database with those parameters.
    my config.php file has these configurations:

    'dbconfig' =>
    array (
    'db_host_name' => 'localhost',
    'db_host_instance' => 'SQLEXPRESS',
    'db_user_name' => 'xxxxxxxx',
    'db_password' => 'xxxxxxx',
    'db_name' => 'sugarcrmheb',
    'db_type' => 'mysql',
    'db_port' => '',
    'db_manager' => 'MysqliManager',
    ),

    do i put the parameters here somewhere?

    (i think i need to add these parameters so reports with hebrew characters (utf-8) in them will work - they don't work right now)
    rodnikosh likes this.

  3. #3
    rodnikosh Guest

    Default Re: set sugarcrm a connection string to database with parameters

    Thank you christian

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. SugarCRM database connection
    By limj1005 in forum Developer Help
    Replies: 13
    Last Post: 2012-01-17, 10:57 AM
  2. Replies: 5
    Last Post: 2011-09-06, 07:26 PM
  3. SugarCRM connection string
    By limj1005 in forum Developer Help
    Replies: 0
    Last Post: 2010-03-16, 03:34 AM
  4. Connection string for sql 08
    By romalagajini in forum General Discussion
    Replies: 1
    Last Post: 2009-06-24, 05:34 PM
  5. Database string in quote pdf name
    By gdoss in forum General Discussion
    Replies: 0
    Last Post: 2006-04-10, 08:21 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •