[TYPO3-english] Charsets in mysql

[Damien Sauveron]

I do not know if it can help:

http://xavier.perseguers.ch/en/tutorials/typo3/configuration/utf-8.html

Best regards,
Damien

Marcel Remmy a écrit :
> hey tomaz,
> 
> sorry if i mainly say the same like andreas, but my advice is to not go
> the path where you patchwork your database with all kinds of encodings.
> go for clean utf-8 which is no hype or something, it's just the way data
> should go nowadays.
> 
> the tool you need for is a small command line tool called recode or
> iconv, if you are on a linux shell.
> 
> you mention the template (sys_templates) that won't be encoded
> correctly. here is how i got rid of the exact same problem:
> 
> export your sys_template sql (convently with a tool like phpmyadmin) and
> make sure you export blob not in hex but in binary. this way your
> template setup and constants are recoded as well.
> 
> then change your collation stuff and import the now recoded file again.
> worked for me.
> 
> good luck,
> 
> marcel
> 
> 
> Tomaz Zaman wrote:
>> Tried that, but i don't think i have the right tools for that.
>>
>> And other things get broken if i do that (templates mainly)
>> That said i would only need to convert fe_users, pages, and tt_content
>> tables, but as i said, the tools i found only change charsets and
>> collations, but none actually convert the data
>>
>> Tomaz Zaman
>>
>> Andreas Becker wrote:
>>> Hi Tomaz
>>> Why don't you convert the complete database instead of doing work
>>> piece by
>>> piece. You will always again get to the point where it would be good
>>> to have
>>> a clean utf8. It is at least worth a try, don't worry about the size to
>>> much.
>>>
>>> Andi
>>>
>>>
>>> On Mon, Apr 20, 2009 at 8:08 PM, Tomaz Zaman <tomaz at optiss.si> wrote:
>>>
>>>> Hey
>>>>
>>>> I made an extension that list FE users, all went well, but now i have a
>>>> small problem, I need to fetch users from database, but i would like to
>>>> use 'SET NAMES utf8' ONLY(!!!) when querying for fe_users.
>>>>
>>>> Is that possible?
>>>>
>>>> (I made a mistake in not putting 'SET NAMES utf8' when the website was
>>>> set up, now it is about 3GB big, so i cannot manually fix characters -
>>>> the only ones that can be updated are fe users, because i get them from
>>>> an LDAP server)
>>>>
>>>> Tomaz Zaman
>>>> _______________________________________________
>>>> TYPO3-english mailing list
>>>> TYPO3-english at lists.netfielders.de
>>>> http://lists.netfielders.de/cgi-bin/mailman/listinfo/typo3-english
>>>>
> _______________________________________________
> TYPO3-english mailing list
> TYPO3-english at lists.netfielders.de
> http://lists.netfielders.de/cgi-bin/mailman/listinfo/typo3-english