Re: [TYPO3-english] Typoscript non-latin characters not saving
Hi! Jigal van Hemert wrote: A bit off-topic in this thread, but if the database server has a default character set which can at least store the characters in utf-8 this setting is not needed. This setting should IMO be done in the server and not at the beginning of a connection. Absolutely true but I still see servers that are configured to use latin1 as a default :( -- Dmitry Dulepov ___ TYPO3-english mailing list TYPO3-english@lists.typo3.org http://lists.typo3.org/cgi-bin/mailman/listinfo/typo3-english
Re: [TYPO3-english] Typoscript non-latin characters not saving
On 24/07/2013 5:47 PM, Jigal van Hemert wrote: Hi, On 24-7-2013 3:48, David Cumberbeach wrote: Does TYPO3 support utf-8 or non-latin characters in typoscript? Yes! Using TYPO3 4.7.12 Just tested on 4.7.13, added ῷﻒﬡṏЮ慦挏뜊ﬗﴣ to TS (I think this covers large parts of the unicode set). It was visible in the editor after saving and visible in the frontend output. I have the database character set collation as UTF-8 unicode. localconf.php has the following $TYPO3_CONF_VARS['SYS']['setDBinit'] = 'SET NAMES utf8;'.chr(10).'SET SESSION character_set_server=utf8;'; SET NAMES utf8; is enough. This sets all the necessary options to UTF-8. Thanks, I've yet to track down where my configuration has gone wrong, but it's good to know it's possible. I've used a workaround in the meantime: using html entities (references to the unicode glyph number). This works but would be tedious for large amounts of text of course. ___ TYPO3-english mailing list TYPO3-english@lists.typo3.org http://lists.typo3.org/cgi-bin/mailman/listinfo/typo3-english
Re: [TYPO3-english] Typoscript non-latin characters not saving
Hi, On 24-7-2013 3:48, David Cumberbeach wrote: Does TYPO3 support utf-8 or non-latin characters in typoscript? Yes! Using TYPO3 4.7.12 Just tested on 4.7.13, added ῷﻒﬡṏЮ慦挏뜊ﬗﴣ to TS (I think this covers large parts of the unicode set). It was visible in the editor after saving and visible in the frontend output. I have the database character set collation as UTF-8 unicode. localconf.php has the following $TYPO3_CONF_VARS['SYS']['setDBinit'] = 'SET NAMES utf8;'.chr(10).'SET SESSION character_set_server=utf8;'; SET NAMES utf8; is enough. This sets all the necessary options to UTF-8. -- Jigal van Hemert TYPO3 CMS Active Contributor TYPO3 inspiring people to share! Get involved: typo3.org ___ TYPO3-english mailing list TYPO3-english@lists.typo3.org http://lists.typo3.org/cgi-bin/mailman/listinfo/typo3-english
Re: [TYPO3-english] Typoscript non-latin characters not saving
Hi! Jigal van Hemert wrote: I have the database character set collation as UTF-8 unicode. localconf.php has the following $TYPO3_CONF_VARS['SYS']['setDBinit'] = 'SET NAMES utf8;'.chr(10).'SET SESSION character_set_server=utf8;'; SET NAMES utf8; is enough. This sets all the necessary options to UTF-8. Except character_set_server. -- Dmitry Dulepov ___ TYPO3-english mailing list TYPO3-english@lists.typo3.org http://lists.typo3.org/cgi-bin/mailman/listinfo/typo3-english
Re: [TYPO3-english] Typoscript non-latin characters not saving
Found it: http://www.dmitry-dulepov.com/2008/06/migrating-typo3-installation-to.html: Transferring the database Your source and target web servers should have the same character set and collation settings. You can view them using mysql command line utility: show variables like 'character_set_%'; show variables like 'collation_%'; If these settings do not match, my.cnf settings on destination server should be adjusted. If changing my.cnf settings is not possible, you can put adjustments into setDBInit in Install tool. For example, to convert server fully to UTF8 for the current session, do: SET NAMES utf8 SET SESSION character_set_server=utf8 The first command changes all settings except character_set_server. The second one changes settings for server. If that stays latin1 (not UTF8), most likely you will get weird errors (like Field was not properly updated in the database) when saving records with non-English characters. Dmitry Dulepov wrote: Hi! Jigal van Hemert wrote: I have the database character set collation as UTF-8 unicode. localconf.php has the following $TYPO3_CONF_VARS['SYS']['setDBinit'] = 'SET NAMES utf8;'.chr(10).'SET SESSION character_set_server=utf8;'; SET NAMES utf8; is enough. This sets all the necessary options to UTF-8. Except character_set_server. -- Dmitry Dulepov ___ TYPO3-english mailing list TYPO3-english@lists.typo3.org http://lists.typo3.org/cgi-bin/mailman/listinfo/typo3-english
Re: [TYPO3-english] Typoscript non-latin characters not saving
Hi, On 24-7-2013 10:47, Dmitry Dulepov wrote: SET NAMES utf8; is enough. This sets all the necessary options to UTF-8. Except character_set_server. A bit off-topic in this thread, but if the database server has a default character set which can at least store the characters in utf-8 this setting is not needed. This setting should IMO be done in the server and not at the beginning of a connection. -- Jigal van Hemert TYPO3 CMS Active Contributor TYPO3 inspiring people to share! Get involved: typo3.org ___ TYPO3-english mailing list TYPO3-english@lists.typo3.org http://lists.typo3.org/cgi-bin/mailman/listinfo/typo3-english
[TYPO3-english] Typoscript non-latin characters not saving
I'm trying to setup a language selection menu with English and Korean. I'd like to render the Korean menu item/label in Korean (therefore not in latin characters). So far though, when I paste the characters into the template setup, they appear to paste correctly, but when the template setup is re-opened the characters have not saved correctly and appear instead as question marks (???). The menu item appears this way in the front end also. Does TYPO3 support utf-8 or non-latin characters in typoscript? Using TYPO3 4.7.12 I have the database character set collation as UTF-8 unicode. localconf.php has the following $TYPO3_CONF_VARS['SYS']['setDBinit'] = 'SET NAMES utf8;'.chr(10).'SET SESSION character_set_server=utf8;'; $TYPO3_CONF_VARS['BE']['forceCharset'] = 'utf8'; Here's my language menu setup: lib.langMenu = HMENU lib.langMenu { special = language special.value = 0,1 special.normalWhenNoLanguage = 0 1 = TMENU 1 { # Normal link to language that exists: NO = 1 NO.allWrap = |*| | |*| | NO.linkWrap = b | /b NO.stdWrap.setCurrent = English || ??? NO.stdWrap.current = 1 # Current language selected: ACT .NO ACT.linkWrap = b | /b # Language that is NOT available: USERDEF1 .NO USERDEF1.linkWrap = span | /span USERDEF1.doNotLinkIt = 1 } } Thanks in advance, David Cumberbeach ___ TYPO3-english mailing list TYPO3-english@lists.typo3.org http://lists.typo3.org/cgi-bin/mailman/listinfo/typo3-english