db.xml and varbinary

Permalink
Hi

I have a table in my database, where I store AES-Encrypted passwords. The password table is created by the packages db.xml. This works great. But it makes a varchar field.

How can I create a field with the varbinary field type by installing the package?

db.xml snippet:
<table name="btSteffPasswords">
   <field name="passID" type="I">
      <key />
      <autoincrement />
   </field>
   <field name="passUser" type="C" size="255"></field>
   <field name="passWord" type="C" size="255"></field>
</table>


Thanks and kind regards,
Steff

Steff
View Replies: View Best Answer
LucasAnderson replied on at Permalink Best Answer Reply
LucasAnderson
There's a great How To on working with db.xml files. Maybe it can help you?

http://www.concrete5.org/documentation/how-tos/developers/creating-...
Steff replied on at Permalink Reply
Steff
Thank you Lucas

But this is the same information I also get here:
http://phplens.com/lens/adodb/docs-datadict.htm...

But I just figured out, it also works with a Blob instead of a varbinary.