Naming Practices: Authorized Values & Patron Attributes
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 http://www.stlib.state.nm.us/
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
Okay - the best thing to do is always check the SQL structure (that said I will update the new manual with this info) http://git.koha.org/cgi-bin/gitweb.cgi?p=Koha;a=blob_plain;f=installer/data/... The link is VARCHAR(10) on patron attribute codes as well as authorized values. And when you're writing codes it's good practice to only have characters and numbers - no symbols. Nicole On Wed, Nov 4, 2009 at 5:25 PM, Agnes Rivers-Moore <arm@hanover.ca> wrote:
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
_______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
participants (3)
-
Agnes Rivers-Moore -
Chris Mueller -
Nicole Engard