search

mortadam / relay

Automatically exported from code.google.com/p/relay
MIT License
0 stars 0 forks source link

UTF8 kills database creation #17

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago 
What steps will reproduce the problem?
1. Use UTF-8 database
2. Install
3.

What is the expected output? What do you see instead?
Database Connected....
done
Dropping tables if the exist...done
Creating tables
*relay_clients...Specified key was too long; max key length is 1000 bytes could 
not create the table clients

What version of the product are you using? On what operating system?

Please provide any additional information below.

Reason is that UTF-8 needs 1-3 bytes to store characters. So, the index pn 
(path(250),name(250) is taking up more than 1000 bytes when the database is in 
UTF-8. Solution is reducing to 250 to 165 each.

Original issue reported on code.google.com by reinier....@gmail.com on 31 Aug 2011 at 7:59