| Character encoding/decoding to UTF-8 [message #768539] |
Tue, 20 December 2011 10: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 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  |
|
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
|
|
|
Powered by
FUDForum. Page generated in 0.01613 seconds
Search
Help
Register
Login
Home
