X-Git-Url: http://git.rot13.org/?a=blobdiff_plain;f=ffzg_inventura.sql;h=7bbd382fa7b9a9c2d899a50e7f1c6b66a643d652;hb=43d61f4b7879fefe1511b4d576255cef4b22bb0b;hp=94109bb58aa089e4b527cddbe34f827a207d18df;hpb=673f9ae7c7b2d17bf680df262fd68ecadff3022e;p=koha-dla

diff --git a/ffzg_inventura.sql b/ffzg_inventura.sql
index 94109bb..7bbd382 100644
--- a/ffzg_inventura.sql
+++ b/ffzg_inventura.sql
@@ -4,4 +4,6 @@ create table ffzg_inventura (
 	source_id varchar(20) not null,
 	timestamp datetime default now(),
 	unique key ffzg_inventura_unique (barcode,date_scanned,source_id)
-); 
+) DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ;
+-- this collate has to be same as barcode in items check it with:
+-- show create table items