<html>
<head>
<meta content="text/html; charset=utf-8" http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<div class="moz-cite-prefix">Hello Martin,<br>
<br>
first of all, welcome on the list :)<br>
<br>
As for your problem, there are two solutions:<br>
<br>
1) For <b>extension attributes</b> you can simply turn off
storing of their string value into the database. They would be
stored only as a part of XML representation of the user in the
FULLOBJECT column, which has no size limit. <br>
<br>
An advantage of this solution is its simplicity (just editing the
extension schema).<br>
A disadvantage is that you'll lose the possibility to construct
queries related to this attribute. For example, you'll not be able
to look for all objects having a particular value for this
attribute.<br>
<br>
Specifically, you just have to include the following to the
schema:<br>
<br>
<tt><xsd:schema elementFormDefault="qualified"</tt><tt><br>
</tt><tt> targetNamespace=<a class="moz-txt-link-rfc2396E" href="http://whatever.com/my">"http://whatever.com/my"</a></tt><tt><br>
</tt><tt> xmlns:tns=<a class="moz-txt-link-rfc2396E" href="http://whatever.com/my">"http://whatever.com/my"</a></tt><tt><br>
</tt><tt>
xmlns:a=<a class="moz-txt-link-rfc2396E" href="http://prism.evolveum.com/xml/ns/public/annotation-3">"http://prism.evolveum.com/xml/ns/public/annotation-3"</a></tt><tt><br>
</tt><tt>
xmlns:c=<a class="moz-txt-link-rfc2396E" href="http://midpoint.evolveum.com/xml/ns/public/common/common-3">"http://midpoint.evolveum.com/xml/ns/public/common/common-3"</a></tt><tt><br>
</tt><tt>
xmlns:xsd=<a class="moz-txt-link-rfc2396E" href="http://www.w3.org/2001/XMLSchema">"http://www.w3.org/2001/XMLSchema"</a>></tt><tt><br>
</tt><tt><br>
</tt><tt> <xsd:complexType name="UserExtensionType"></tt><tt><br>
</tt><tt> <xsd:annotation></tt><tt><br>
</tt><tt> <xsd:appinfo></tt><tt><br>
</tt><tt> <a:extension ref="c:UserType"/></tt><tt><br>
</tt><tt> </xsd:appinfo></tt><tt><br>
</tt><tt> </xsd:annotation></tt><tt><br>
</tt><tt> <xsd:sequence></tt><tt><br>
</tt><tt> <xsd:element name="description"
type="xsd:string"></tt><tt><br>
</tt><tt> <xsd:annotation></tt><tt><br>
</tt><tt> <xsd:appinfo></tt><tt><br>
</tt><tt> <b><font color="#cc0000"><a:indexed>false</a:indexed></font></b></tt><tt><br>
</tt><tt> </tt><tt> </xsd:appinfo></tt><tt><br>
</tt><tt> </xsd:annotation></tt><tt><br>
</tt><tt> <</tt><tt>/xsd:element></tt><tt><br>
</tt><tt> </xsd:sequence></tt><tt><br>
</tt><tt> </xsd:complexType></tt><tt><br>
</xsd:schema><br>
</tt><br>
However, in order for this to work, you have to use the latest
master (v3.2devel-277-g65cbe8a or later). Use with caution, as it
might be a bit unstable.<br>
<br>
2) For <b>standard attributes</b> as well as for extension
attributes that you want to search for, you have to change the DB
schema, as you said. Currently there is no other solution.<br>
Please note that some databases (e.g. MySQL) are limited in the
size allowed for the indices, so e.g. unique constraints might not
work properly for large strings.<br>
<br>
Best regards,<br>
Pavol<br>
<br>
On 19. 3. 2015 19:48, Martin Lízner - AMI Praha a.s. wrote:<br>
</div>
<blockquote
cite="mid:CALOh8eMMKakF90O9g1PerrMo=9S2854-B6Y61bWU=tBQjX32ZA@mail.gmail.com"
type="cite">
<div dir="ltr">Hello everybody, Im new to midPoint and to this
list :-) As ex-Sun IdM fan, Im glad that Evolveum picked up the
strong customization concept from Sun IdM, while introducing
many new features and technologies.
<div><br>
</div>
<div>I have found limitation in length of user attribute -
either extended (xsd:string) or default, all of them seem to
be limited to 256 chars. I need more - lets say 1024 long
text. The error message, Im getting is DB varchar column too
short. The obvious resolution would be to extend the varchar
in DB, but maybe Im missing something and there is more
convenient way to do it...? Im using embedded DB atm.</div>
<div><br>
</div>
<div>Thanks, Martin<br>
<div><br clear="all">
<div>
<div class="gmail_signature">
<div dir="ltr">
<div>
<table
style="font-family:Verdana,Arial,Helvetica,sans-serif;border-collapse:collapse;padding:0px;margin:0px;border-width:0px!important;border-style:solid!important;width:482px!important">
<tbody>
<tr style="padding:0px;margin:0px;border:0px
solid gray!important">
<td colspan="2"
style="color:rgb(0,0,0);font-family:Arial,sans-serif;font-size:11px;vertical-align:bottom;padding:0px;border:0px
solid gray!important">
<p><span
style="font-size:14px;font-weight:bold">Martin
Lízner</span><br>
solution architect<br>
<br>
gsm: [+420] 737 745 571<br>
e-mail: <a moz-do-not-send="true"
href="mailto:jmeno.prijmeni@ami.cz"
target="_blank">martin.lizner@ami.cz</a></p>
</td>
<td
style="color:rgb(0,0,0);font-family:Verdana,Arial,Helvetica,sans-serif;font-size:10px;border-right-width:1px;border-right-style:solid;border-right-color:rgb(204,204,204);padding:0px;border-top-width:0px!important;border-bottom-width:0px!important;border-left-width:0px!important;border-top-style:solid!important;border-bottom-style:solid!important;border-left-style:solid!important;border-top-color:gray!important;border-bottom-color:gray!important;border-left-color:gray!important"> </td>
<td
style="color:rgb(0,0,0);font-family:Verdana,Arial,Helvetica,sans-serif;font-size:10px;padding:0px;border:0px
solid gray!important"> </td>
<td
style="color:rgb(0,0,0);font-family:Arial,sans-serif;font-size:11px;vertical-align:bottom;padding:0px;border:0px
solid gray!important">
<p>AMI Praha a.s.<br>
Pláničkova 11<br>
162 00 Praha 6<br>
tel.: [+420] 274 783 239<br>
web: <a moz-do-not-send="true"
href="http://www.ami.cz/"
target="_blank">www.ami.cz</a></p>
</td>
<td
style="color:rgb(0,0,0);font-family:Verdana,Arial,Helvetica,sans-serif;font-size:10px;border-right-width:1px;border-right-style:solid;border-right-color:rgb(204,204,204);padding:0px;border-top-width:0px!important;border-bottom-width:0px!important;border-left-width:0px!important;border-top-style:solid!important;border-bottom-style:solid!important;border-left-style:solid!important;border-top-color:gray!important;border-bottom-color:gray!important;border-left-color:gray!important"> </td>
<td
style="color:rgb(0,0,0);font-family:Verdana,Arial,Helvetica,sans-serif;font-size:10px;padding:0px;border:0px
solid gray!important"> </td>
<td
style="color:rgb(0,0,0);font-family:Arial,sans-serif;font-size:11px;margin:8px;border:0px
solid gray!important">
<p><img moz-do-not-send="true"
src="http://www.ami.cz/images/podpis/ami_logo.gif"
alt="" style="border: 0px;"></p>
</td>
</tr>
<tr style="padding:0px;margin:0px;border:0px
solid gray!important">
<td colspan="8"
style="color:rgb(0,0,0);font-family:Verdana,Arial,Helvetica,sans-serif;font-size:10px;padding:0px;border:0px
solid gray!important"><br>
<a moz-do-not-send="true"
href="http://www.ami.cz/reseni-a-sluzby/bezpecnost-dat/audit-roli-a-opravneni-sap"
target="_blank"><img
moz-do-not-send="true"
src="http://www.ami.cz/images/podpis/AMI-podpis-AuditSAP_1.png"
alt="" style="border: 0px; width: 480px;
height: 82px;"></a></td>
</tr>
<tr style="padding:0px;margin:0px;border:0px
solid gray!important">
<td colspan="8"
style="color:rgb(128,128,128);font-family:Arial,sans-serif;font-size:11px;padding:0px;border:0px
solid gray!important"><br>
Textem tohoto e-mailu podepisující neslibuje
uzavřít ani neuzavírá za společnost AMI
Praha a.s.<br>
jakoukoliv smlouvu. Každá smlouva, pokud
bude uzavřena, musí mít výhradně písemnou
formu.</td>
</tr>
</tbody>
</table>
</div>
<br>
</div>
</div>
</div>
</div>
</div>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
midPoint mailing list
<a class="moz-txt-link-abbreviated" href="mailto:midPoint@lists.evolveum.com">midPoint@lists.evolveum.com</a>
<a class="moz-txt-link-freetext" href="http://lists.evolveum.com/mailman/listinfo/midpoint">http://lists.evolveum.com/mailman/listinfo/midpoint</a>
</pre>
</blockquote>
<br>
</body>
</html>