Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » Eclipse Process Manager (Stardust) » Character encoding/decoding to UTF-8(Special characters are being distorted when stored and displayed.)
Character encoding/decoding to UTF-8 [message #768539] Tue, 20 December 2011 10:34 Go to next message
Ghanshyam Baheti is currently offline 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 12:10]

Report message to a moderator

Re: Character encoding/decoding to UTF-8 [message #815828 is a reply to message #768539] Thu, 08 March 2012 04:41 Go to previous message
Robert Emsbach is currently offline Robert Emsbach
Messages: 121
Registered: October 2011
Location: Singapore
Senior 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
Previous Topic:Model loading fails with exception
Next Topic:"java.net.SocketException: Too many open files" error on the Stardust portal
Goto Forum:
  


Current Time: Thu Oct 23 18:05:24 GMT 2014

Powered by FUDForum. Page generated in 0.09080 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software