[rt-users] Issue with iso/utf in 3.8.1?

[Emmanuel Lacour]

On Wed, Aug 20, 2008 at 06:22:28PM +0200, Geir Skjotskift wrote:
> Emmanuel Lacour wrote:
> > You forgot to read UPGRADING.mysql. It will tell you to upgrade format
> > of DB fields as now RT uses full UTF-8 colation.
> 
> hm. Indeed I did. Sorry.
> 
> However, when I do the :
> 
>      mysql -u root -p rt3 < sql.queries
> 
> it tells me :
> 
> Enter password: 
> ERROR 1067 (42000) at line 3: Invalid default value for 'RightName'
> zsh: 6183 exit 1     mysql -u root -p rt3 < sql.queries
> 
> Line three contains : 
> 
> ALTER TABLE ACL MODIFY RightName VARBINARY(25) NOT NULL DEFAULT NULL;
> 

Which RT version you used to generate sql.queries? 3.8.0 or 3.8.1?

(this bug was reported in list before 3.8.1 and should be fixed as I
remember).