[TYPO3-english] Re: [TYPO3] Realurl: uid in tt_news SINGLE-link

2009-10-07 Thread Steffen Müller
Hi. On 05.10.2008 21:53 Steffen Gebert wrote: > Steffen Gebert wrote: >> Yes! There really seems to be a charset issue. >> CONCAT(CONVERT(title using latin1),'-',uid)) >> works! > > I have to just add that links are generated in the right way, but they don't > work... just found this out.. > M

Re: [TYPO3] Realurl: uid in tt_news SINGLE-link

2008-10-05 Thread Dmitry Dulepov
Hi! Steffen Gebert wrote: > I have to just add that links are generated in the right way, but they don't > work... just found this out.. I think it is related to the same charset issue. It seems that the field you use is not in the right charset. Fields in mysql can have charsets separate from

Re: [TYPO3] Realurl: uid in tt_news SINGLE-link

2008-10-05 Thread Steffen Gebert
Steffen Gebert wrote: > Yes! There really seems to be a charset issue. > CONCAT(CONVERT(title using latin1),'-',uid)) > works! I have to just add that links are generated in the right way, but they don't work... just found this out.. Steffen ___ TYPO3-

Re: [TYPO3] Realurl: uid in tt_news SINGLE-link

2008-10-05 Thread Steffen Gebert
Dmitry Dulepov wrote: > Nope :( I am in darkness :( May be mysql field character set is not the > same as data character set? You can try someting like > "concat(convert(field using utf8), '-', uid)". Yes! There really seems to be a charset issue. CONCAT(CONVERT(title using latin1),'-',uid)) work

Re: [TYPO3] Realurl: uid in tt_news SINGLE-link

2008-10-05 Thread Dmitry Dulepov
Hi! Steffen Gebert wrote: > I just found out that this causes wrong replacement of special chars (umlauts > etc): > Title: Neue InterCity-Züge für Holland > URL: neue-intercity-za14ge-fa14r-holland-6567/ > > With just alias_field 'title' it works correct: > neue-intercity-zuege-fuer-holland/

Re: [TYPO3] Realurl: uid in tt_news SINGLE-link

2008-10-05 Thread Steffen Gebert
Hey Dmitry > > Steffen Gebert wrote (13.07.2008): > > I've got to include the uid of tt_news-records in the link to the > > tt_news SINGLE view. > > > > I made this by setting alias_field to 'CONCAT(title,\'-\',uid)'. > > Is this a bad idea / is there any recommended way? Couldn't find > > anyt

Re: [TYPO3] Realurl: uid in tt_news SINGLE-link

2008-07-13 Thread Steffen Gebert
> > I made this by setting alias_field to 'CONCAT(title,\'-\',uid)'. > This is completely ok. It is used also here, for example: > http://support.typo3.org/general/english/m/typo3-realurl-uid-i > n-tt-news-single-link-353301/p/1188/ Many thanks for your reply, Dmitry Steffen

Re: [TYPO3] Realurl: uid in tt_news SINGLE-link

2008-07-13 Thread Dmitry Dulepov [typo3]
Hi! Steffen Gebert wrote: > I've got to include the uid of tt_news-records in the link to the tt_news > SINGLE view. > > I made this by setting alias_field to 'CONCAT(title,\'-\',uid)'. > Is this a bad idea / is there any recommended way? Couldn't find anything. This is completely ok. It is used

[TYPO3] Realurl: uid in tt_news SINGLE-link

2008-07-13 Thread Steffen Gebert
Hey list, I've got to include the uid of tt_news-records in the link to the tt_news SINGLE view. I made this by setting alias_field to 'CONCAT(title,\'-\',uid)'. Is this a bad idea / is there any recommended way? Couldn't find anything. Thanks, Steffen __