Eclipse Community Forums: Eclipse Process Manager (Stardust)

Home » Eclipse Projects » Eclipse Process Manager (Stardust) » Character encoding/decoding to UTF-8(Special characters are being distorted when stored and displayed.)

Show: Today's Messages :: Show Polls :: Message Navigator

Character encoding/decoding to UTF-8 [message #768539]

Tue, 20 December 2011 05:34

Ghanshyam Baheti
Messages: 3
Registered: December 2011

Junior Member

problem:
I am having special characters entered (like İ ş ê õ ö ù, etc.) that are being distorted when stored and displayed in Stardust.
what is way to allow these characters? I am using MYSQL database and Window OS.

solution:
Your page is being displayed in UTF-8, so any text coming out of the database must be UTF-8 encoded.
Database level changes that are required for encoding/decoding the special characters (like umlauts/Turkish) within the schema is as below.

1. Make below setting change for my.ini file 'SERVER SECTION' part of MySQL server and restart MYSQL service.
#default-character-set=latin1 (comment this)
character-set-server=utf8 (add this)
collation-server =utf8_general_ci (add this)

2. Execute DB command to change Character set:
ALTER TABLE structured_data_value CHARACTER SET utf8;
3. Modify Column 'String_Value' from table 'structured_data_value' charset and collation setting to 'utf8' and 'utf8_general_ci' respectively.

It may require to execute the alter command on all the tables where data needs to be made UTF-8 compliant and also change column charset and collation to 'utf8' and 'utf8_general_ci' respectively.
Generally table requiring this change are structured_data_value, data_value and clob_data,etc.

[Updated on: Fri, 30 December 2011 07:10]

Report message to a moderator

Re: Character encoding/decoding to UTF-8 [message #815828 is a reply to message #768539]

Wed, 07 March 2012 23:41

Robert Emsbach
Messages: 56
Registered: October 2011
Location: Shanghai

Member

On Oracle the configured character set can be determined using:

select value from nls_database_parameters where parameter = 'NLS_CHARACTERSET';

Depending on the installed version the default character set is probably WE8MSWIN1252.

This will not be sufficient for instance to store Chinese characters.
One cannot directly run "alter database character set ZHS16GBK;" because ZHS16GBK not a super set of the default character set.

Do not directly modify the PROPS $ table. This will leave a some potential problems!

After installing Oracle you can use sqlplus to modify the character set as described below. (Example for Chinese, adjust character set as needed)

CONNECT / AS sysdba

shutdown immediate

startup mount

alter system enable restricted session;

alter system set JOB_QUEUE_PROCESSES = 0;

alter system set AQ_TM_PROCESSES = 0;

alter database open;

alter database character set internal_use ZHS16GBK;

shutdown immediate

startup

Report message to a moderator

Previous Topic:	Model loading fails with exception
Next Topic:	"java.net.SocketException: Too many open files" error on the Stardust portal

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Jun 18 01:46:30 EDT 2013