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

Geir Skjotskift geir at mnemonic.no
Wed Aug 20 12:22:28 EDT 2008


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;

-geir

-- 
**--**--**--**--**--**--**--**--**--**--**--**--**--**--        
Geir Skjotskift, mnemonic AS    Email : geir at mnemonic.no          
Wergelandsveien 25              Cell  : +47 95 10 51 09              
N-0167 Oslo, NORWAY             Fax   : +47 23 20 47 01              
    Key A2360FF3 availiable at subkeys.pgp.net
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: not available
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20080820/c2e30c84/attachment.sig>


More information about the rt-users mailing list