[Typo3-dev] Blob Fe_users Fe-usergroups

[Karsten Dambekalns]

Hi.

Alain wrote:
> I use the Export function of phpMyAdmin.
> 
> If I do an export using the classical SQL format, here is what I get :
 ...
> (9, 7, 1073570013, 'user', 'password', 0x312c31322c3133, 0, 0, 0,
 ...
> If you look at the field named usergroup with SQL you have the following
> value 0x312c31322c3133 and with CSV : "1,12,13"

There is a switch called "Use hexadecimal for binary fields" in phpMyAdmin
on the export page to change hex export.

> How can I transform my list "1,12,13" in the format 0x312c31322c3133 ?

You can insert it just like that, as if it were a string, in your case.

Karsten
-- 
Karsten Dambekalns
TYPO3 Association - Active Member
http://association.typo3.org/