#1 Cyrillic characters in publishers, series and pub series

[Al von Ruff]

Was: 10014

I'm having some trouble with a Russian-language version of Starman Jones, publication HHHPWLVGLD2002 (http://www.isfdb.org/cgi-bin/pl.cgi?HHHPWLVGLD2002), "Астронавт Джонс". (I think it transliterates to "Astronavt Dzhons"), I entered the publisher as "Центрполиграф", and it appears that was in the submission confirmation screen, but it shows up as "Центрполи&". See the submission confirmation page for Publication Update #38462 (http://www.isfdb.org/cgi-bin/mod/pv_update.cgi?38462). Should I just not be trying to use Cyrillic at all? grendel|khan 17:28, 16 May 2006 (CDT)

See also publication VWCPCRJLQD2002 (http://www.isfdb.org/cgi-bin/pl.cgi?VWCPCRJLQD2002). grendel|khan 21:30, 16 May 2006 (CDT)

Have I mentioned that I hate unicode? Alvonruff 05:57, 17 May 2006 (CDT)

[Ahasuerus]

Cyrillic and other Unicode characters in publishers, series and pub series names cause problems because they are stored as 7+ bytes and the size of these fields is limited to 64 bytes. We need to change the max size of these fields from 64 to "mediumtext", which can hold up to 16MB of data.

[Ahasuerus]

Fixed in change_field_len.sql 1.1, implemented in r2012-07.