Customer login  |   Contact us
Home Company Products Support Purchase
Forum Home » Survey software » Opinio

Topic: Korean characters in Opinio's invitations
Replies: 6   Pages: 1   Last Post: Feb 9, 2010 8:48 PM by: melkiades


Back to Topic List Back to Topic List
Replies: 6   Pages: 1  
melkiades

Posts: 22
From: Montreal
Registered: Oct 14, 2004
Korean characters in Opinio's invitations
Posted: Jan 28, 2010 5:49 AM
  Reply

Hi there,

I have a multilingual survey, 5 languages (German, French, English, Italian, Korean).

Everything works well at the survey level to display Korean characters, but we are unable to create email invitations (with Opinio 6.1 Enterprise) using Korean characters: everything arrives by email with ??? characters instead.

I tried both the text/plain and text/html options, to no avail.

Here's a sample line using those characters:

안녕하십니까

Thank you,
Melkiades

melkiades

Posts: 22
From: Montreal
Registered: Oct 14, 2004
Re: Korean characters in Opinio's invitations
Posted: Jan 28, 2010 6:39 AM
  Reply

Ignore the line where I pasted Korean characters - they are not supported in this forum also.

melkiades

Posts: 22
From: Montreal
Registered: Oct 14, 2004
Re: Korean characters in Opinio's invitations
Posted: Jan 28, 2010 6:51 AM
  Reply

Update:

I just realized that the email must be done in HTML and must be formatted using this:

<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />

Please let me know if it's possible to change this in Opinio and if it can be done for a specific survey and/or for all surveys.

Thank you!
Melkiades

melkiades

Posts: 22
From: Montreal
Registered: Oct 14, 2004
Re: Korean characters in Opinio's invitations
Posted: Feb 8, 2010 6:06 PM
  Reply

It seems that not only are invitations impossible to format in Korean, but when respondents answer, answers are not captured correctly in the database. Everything ends up as ???? everywhere in the database.

The only thing that works, and not even from all computers, is the survey itself: on some machines it is being displayed correctly with Korean characters, and on some others the survey is not legible, all characters showing as squares.

Integrating Korean seems to be a huge mess.

melkiades

Posts: 22
From: Montreal
Registered: Oct 14, 2004
Re: Korean characters in Opinio's invitations
Posted: Feb 8, 2010 8:37 PM
  Reply

More on this:

http://dev.mysql.com/doc/refman/5.0/en/faqs-cjk.html#qandaitem-22-11-1-9

Chances are that by default, the variable character_set_database is set to latin1 when it should be set to utf8.

This means that even if Opinio's panel shows utf8 as the Character Encoding in the Setup screen, it does not mean that your database is able to store in utf8 format.

This command will change your opinio database to utf8, but until Object Planet confirms it, use at your own risk:

make sure that you use the following command first:

mysql> use #your_database_name#

and then to change to utf-8:

mysql> set @@character_set_database = utf8;


You can then verify the value of that variable:

mysql> SHOW VARIABLES LIKE 'char%';

melkiades

Posts: 22
From: Montreal
Registered: Oct 14, 2004
Re: Korean characters in Opinio's invitations
Posted: Feb 9, 2010 1:40 AM
  Reply

Changing the character_set_database variable has no effect: our korean surveys still stores comments as ??? characters throughout.

If anyone can think of a solution please let me know.

melkiades

Posts: 22
From: Montreal
Registered: Oct 14, 2004
Re: Korean characters in Opinio's invitations
Posted: Feb 9, 2010 8:48 PM
  Reply

The problem was finally solved by following the procedure listed here:

http://cameronyule.com/2008/07/configuring-mysql-to-use-utf-8



© 1998-2019 ObjectPlanet, Inc. Øvre Slottsgate 5, 0157 Oslo, Norway Tel (+47) 2233 3360 | Fax (+47) 2233 3361