#35 SETTINGS.PHP truncates long Multibyte strings

[Justin White]

In using UTF-8 encoding with some languages, the Titles
of some settings in the Website Configuration module
are truncated.

[Justin White]

Logged In: YES
user_id=483336

This has been fixed in CVS v1.4 of INSTALL/SQL/INSTALL.SQL
and INSTALL/SQL/INSTALL.SQL.ORA. The number of available
ASCII characters was 32, which would be considerably less if
multibyte string were stored in the SETTING_TITLE field of
the WPS_SETTINGS table. This field has been extended to 255
characters, which hopefully will provide enough space for
most titles.

For anyone using v2.1 RC2 or earlier, the field size must be
adjusted manually to accomodate the additional characters.
Consult your vendor's SQL documentation to determine how
this function is supported. You can also post a Support
request
(https://sourceforge.net/tracker/?group_id=54474&atid=473864)
to ask for additional help if no direction can be found.

No further extensions of SETTING_TITLE can be made, since
few RDBMS support the VARCHAR type beyond 255 characters
(notably Oracle, Frontbase, Interbase, and FirebirdSQL). A
further fix could be created, but a new field would have to
be added with uses a BLOB or TEXT type (again, Oracle and
others do not support the TEXT type, instead using
VARCHAR(4000) for long strings not stored as BLOBs).

I am leaving this bug as "Open" to allow everyone the chance
to see this issue and what is required to fix it.