doc/book/en/annexes/faq.rst
branchstable
changeset 6350 74575fb32a4d
parent 5924 b218df942dd4
child 6352 2259d834d757
--- a/doc/book/en/annexes/faq.rst	Tue Sep 28 08:36:24 2010 +0200
+++ b/doc/book/en/annexes/faq.rst	Tue Sep 28 12:22:17 2010 +0200
@@ -402,6 +402,12 @@
     mydb=> update cw_cwuser set cw_upassword='qHO8282QN5Utg' where cw_login='joe';
     UPDATE 1
 
+if you're running over SQL Server, you need to use the CONVERT
+function to convert the string to varbinary(255). The SQL query is
+therefore::
+
+    update cw_cwuser set cw_upassword=CONVERT(varbinary(255), 'qHO8282QN5Utg') where cw_login='joe';
+
 You can prefer use a migration script similar to this shell invocation instead::
 
     $ cubicweb-ctl shell <instance>