[Koha] Naming Practices: Authorized Values & Patron Attributes

[Nicole Engard]

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/mysql/kohastructure.sql;hb=HEAD

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 at 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 at state.nm.us <mailto:christine.mueller at state.nm.us>
>> http://www.stlib.state.nm.us/
>> ------------------------------------------------------------------------
>>
>> _______________________________________________
>> Koha mailing list
>> Koha at 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 at lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha
>