[Koha-devel] kohastructure.sql : columns with COLLATE

[Pasi Kallinen]

Also see https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=20269 <https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=20269>

-- 
Pasi Kallinen
Koha-Suomi oy
+358 400 174 235



Sep 27, 2019, 20:05 by tomascohen at gmail.com:

> I think it doesn't really make sense. There are cases in which the general table collation is utf8mb4_unicode_ci and some columns need utf8mb4_binary. I think those are the only meaningful ones.
>
> El vie., 27 sept. 2019 a las 11:27, Fridolin SOMERS (<> fridolin.somers at biblibre.com <mailto:fridolin.somers at biblibre.com>> >) escribió:
>
>> Hi
>>  
>>  I'm working on DB structure compare.
>>  I note that in installer/data/mysql/kohastructure.sql, a few columns 
>>  define CHARACTER SET and/or COLLATE, with same values as table.
>>  
>>  Is this usefull or should we remove it ?
>>  
>>  $ grep  'COLLATE' installer/data/mysql/kohastructure.sql  | grep -v 
>>  ENGIN | grep 'utf8mb4_unicode_ci'
>>     `category_name` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL 
>>  DEFAULT '',
>>     `font` char(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT 
>>  NULL DEFAULT 'TR',
>>     `text_justify` char(1) CHARACTER SET utf8mb4 COLLATE 
>>  utf8mb4_unicode_ci NOT NULL DEFAULT 'L',
>>     `auto_renew_error` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT 
>>  NULL, -- automatic renewal error
>>     `auto_renew_error` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT 
>>  NULL, -- automatic renewal error
>>     `suppliers_report` MEDIUMTEXT COLLATE utf8mb4_unicode_ci, -- reports 
>>  received from suppliers
>>         entity varchar(16) COLLATE utf8mb4_unicode_ci NOT NULL,
>>         code varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL,
>>         lang varchar(25) COLLATE utf8mb4_unicode_ci NOT NULL, -- could be 
>>  a foreign key
>>         translation MEDIUMTEXT COLLATE utf8mb4_unicode_ci,
>>     `branchcode` varchar(10) CHARACTER SET utf8mb4 COLLATE 
>>  utf8mb4_unicode_ci DEFAULT NULL,
>>  
>>  -- 
>>  Fridolin SOMERS <>> fridolin.somers at biblibre.com <mailto:fridolin.somers at biblibre.com>>> >
>>  BibLibre, France - software and system maintainer
>>  _______________________________________________
>>  Koha-devel mailing list
>>  >> Koha-devel at lists.koha-community.org <mailto:Koha-devel at lists.koha-community.org>
>>  >> https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel <https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel>
>>  website : >> http://www.koha-community.org/ <http://www.koha-community.org/>
>>  git : >> http://git.koha-community.org/ <http://git.koha-community.org/>
>>  bugs : >> http://bugs.koha-community.org/ <http://bugs.koha-community.org/>
>>
>
>
> -- 
> Tomás Cohen Arazi
> Theke Solutions (> http://theke.io <http://theke.io/>> )
> ✆ +54 9351 3513384
> GPG: B2F3C15F
>