|Character encoding/decoding to UTF-8 [message #768539]
||Tue, 20 December 2011 05:34
| Ghanshyam Baheti
Registered: December 2011
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.
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
Powered by FUDForum
. Page generated in 0.13721 seconds