Re: [Sqlgrey-users] Sqlgrey dies while creating mysql tables

[Dan F. <da...@ha...>]

Ahh yes...

Lionel helped someone not long ago who had problems, and it turned out 
to be a UNICODE problem. Here's a quote from the mailing list:

"Hum, did you try to use a database with ASCII instead of UNICODE?
SQLgrey doesn't try to speak utf-8 with the database but only pure ASCII."

Andrew wrote a helpfull mail on how to migrate to ASCII.
 From the maillinglist archives:
http://sourceforge.net/mailarchive/message.php?msg_id=37802061


On a side note. Since more ppl will have this problem, im thinking we 
should either support other encodings or at least warn on execution of 
sqlgrey.

Anyone got some thoughts about either of theese?
- How hard is it to support all encodings
- How do we detect if database is ASCII

If we get a real simple solution, ill try and implement it very soon.

- Dan


Juraj Variny wrote:
> Hello,
>
>  perl -MDBI -le 'my $db=DBI->connect("DBI:mysql:database=sqlgrey;host=localhost","myuser","mypass",undef) or die "Error:$DBI::errstr".$db->disconnect()'
>
>  passed without failure and output nothing. Then I tried to create the table, with very interesting result:
>
> perl -MDBI -le 'my $db=DBI->connect("DBI:mysql:database=sqlgrey;host=localhost","u_sqlgrey","greysql",undef); $db->do("CREATE TABLE from_awl (sender_name varchar(64) NOT NULL, sender_domain varchar(255) NOT NULL, src varchar(39) NOT NULL, first_seen timestamp NOT NULL, last_seen timestamp NOT NULL, PRIMARY KEY (src, sender_domain, sender_name))");$db->disconnect();'
> DBD::mysql::db do failed: Specified key was too long; max key length is 1000 bytes at -e line 1.
>
> According to http://bugs.mysql.com/bug.php?id=4541 , it seems the culprit is that I have utf8 database....
>
> Juraj
>
> On Wednesday 10 January 2007 20:57, Winfried Neessen wrote:
> (snip)
>   
>> `---
>> please open a shell an execute this line an send us what error that is
>> returned by it:
>>
>> ,---
>>
>> | perl -MDBI -le 'my
>> | $db=DBI->connect("DBI:mysql:database=sqlgrey;host=localhost","youruser","
>> |yourpass",undef) or die "Error: $DBI::errstr"$db->disconnect()'
>>
>> `---
>>
>> Regards
>> Winfried
>>     
>
> -------------------------------------------------------------------------
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share your
> opinions on IT & business topics through brief surveys - and earn cash
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> _______________________________________________
> Sqlgrey-users mailing list
> Sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sqlgrey-users
>
>