[Devel] CVS commitlog: sip-server/scripts mysqldb.sh

[Bogdan-Andrei Iancu]

User: bogdan_iancu
Date: 2006/12/05 10:51:09 PST

  OpenSER CVS - Commit Details

  Modified files:
    scripts              mysqldb.sh 
  Commit Log:
  Fixed problem when creating tables using default "utf8" or "ucs2" charsets - they use 3 bytes for char and generates error about the lenght of the keys:
    ERROR 1071 (42000): Specified key was too long; max key length is 1000 bytes
  Solution was to:
  1) Test what's the character encoding is used in database.
  2) If it's a UCS-2 or UTF8 (where 3 bytes per char are used) then warn
  user that db couldn't be created and prompt him to select another
  character encoding among available.
  3) In a "CREATE DATABASE" use closure "CHARACTER SET"
  
   Patch submitted by Khalukhin Alexander <khalukhin at gmail.com>.Thanks!!
   Closes bug 1605410.
   http://sourceforge.net/tracker/index.php?func=detail&aid=1605410&group_id=139143&atid=743020
  
  Revision  Changes    Path
  1.44      +22 -2     sip-server/scripts/mysqldb.sh
   [ http://openser.cvs.sourceforge.net/openser/sip-server/scripts/mysqldb.sh?r1=1.43&r2=1.44 ]