[Koha] Subject headings in CAPS - convert to "proper"

[Robin Sheat]

Hartman, David W. - GBTS Library schreef op wo 23-11-2011 om 10:07
[-0500]:
>   Is there a command in SQL to convert my all CAPS subject heading to
> proper?  Or Koha?  Thanks in advance for any help!

There is 'lower' and 'upper', but I'm not aware of anything in MySQL
which does the equivalent of 'proper'.

Also, I think the subjects are in MARC rather than a database table, in
which case it'd be hard to do from plain sql anyway. It might be
necessary to write a small perl script to do it.

-- 
Robin Sheat
Catalyst IT Ltd.
✆ +64 4 803 2204
GPG: 5957 6D23 8B16 EFAB FEF8  7175 14D3 6485 A99C EB6D
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 198 bytes
Desc: This is a digitally signed message part
URL: <http://lists.katipo.co.nz/pipermail/koha/attachments/20111124/ede5e19d/attachment.pgp>