[TYPO3-english] Charsets in mysql

[Marcel Remmy]

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
>>>