[daisy] [JIRA] Commented: (DSY-362) Inconsistent handling of case-sensitivity in document/part/field type names (and probably others)

Wed Oct 11 03:18:47 CDT 2006

    [ http://issues.cocoondev.org//browse/DSY-362?page=comments#action_12940 ] 

Aaron Digulla commented on DSY-362:
-----------------------------------

To make this work, two things need to be done:

1. Add a new field U_NAME where the name is stored in uppercase.
2. Filter the values passed in and convert them to uppercase.

I've tried to implement this but I failed for the second item: Is there a limit to what the user can pass here? In the end, my solution was to fix the name *before* I created the query.

Also, the conversion is prone to locale issues.

Sidenote: For some databases, you can create a trigger which automatically fills the U_NAME field but then, you have to different implementations of toUppercase() (the one from the DB and the Java one), so this is no good, except we move this into the DB adapter and both case conversions are handled by the database.

For portability reasons, I would prefer the case conversion in Java. Also, I'm not sure how the DB optimiser handles function calls. It *shouldn't* be an issue here (since we only convert constants) but better be safe.

> Inconsistent handling of case-sensitivity in document/part/field type names (and probably others)
> -------------------------------------------------------------------------------------------------
>
>          Key: DSY-362
>          URL: http://issues.cocoondev.org//browse/DSY-362
>      Project: Daisy
>         Type: Bug
>     Reporter: Bruno Dumon
>     Priority: Minor
>      Fix For: public - 2.0

>
> SQL searches in MySQL are case insensitive, though the names of document/part/field types in Daisy are case-sensitive. Currently it is possible to retrieve e.g. a document type by name even if the casing is not correct, though this does not work when the document type is retrieved from the cache. We need some consequent handling here, also taking care of the fact that other databases are case sensitive.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://issues.cocoondev.org//secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira