LS,
In several projects I have come across the same issue. I want to fix
this in the mmbase code Searches on fields with case-insensitive
queries fail, because rhe column in the database is of type blob. The
lower function does not work on blobs. I know that there are some
issues with mysql and enoding which mmbase works around by adding bytes
to the database in iso8859-1 format. I don't want to change this.
The only thing I want to change is the mysql.xml.
<type-mapping name="STRING" min-size="1" max-size="255"
type="varchar({0})" />
<type-mapping name="STRING" min-size="256" max-size="65535"
type="text" />
<type-mapping name="STRING" min-size="65536" max-size="16777216"
type="mediumtext" />
<type-mapping name="XML" min-size="1" max-size="255"
type="varchar({0})" />
<type-mapping name="XML" min-size="256" max-size="65535" type="text" />
<type-mapping name="XML" min-size="65536" max-size="16777216"
type="mediumtext" />
This will create colums with type text to mysql which makes it possible
to use the lower function. I have tested this change and didn't find
side-effect. Euro signs and other chanacters still work.
Anybody objections for this change?
Nico
_______________________________________________
Developers mailing list
[email protected]
http://lists.mmbase.org/mailman/listinfo/developers
