You are right about the special characters. I once tried to set up a Patron Attribute called Fire# and broke all kinds of things. Agnes Chris Mueller wrote:
What are "best practices" when creating new categories for Authorized Values and new codes for Patron Attributes?
By accident I found that the maximum number of characters for a new Authorized Values category is 10. -- Nicole: Can this type of info be added to the documentation please?
Suspect there is a maximum number of characters for new Patron Attributes codes but prefer not to create test codes until I find one which is too long. Anyone know what the max number is?
Also suspect that there might be problems with SQL statements if any special characters are used in the categories and codes, other than perhaps "_" and "." (underscore and period). Is it best to use only alpha characters when naming categories and codes?
Thanks for any insights and guidance. Chris
Christine Mueller Database Administrator Office of Information Technology New Mexico State Library 1209 Camino Carlos Rey Santa Fe, NM 87507 Phone: 505-476-9744 christine.mueller@state.nm.us <mailto:christine.mueller@state.nm.us> http://www.stlib.state.nm.us/ ------------------------------------------------------------------------
_______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
------------------------------------------------------------------------
This email was Anti Virus checked by Astaro Security Gateway. http://www.astaro.com
-- Agnes Rivers-Moore Assistant Librarian Hanover Public Library