Re[2]: I can't understand

2001-03-12 Thread Rimantas Liubertas
Hello P.Peti, Monday, March 12, 2001, 11:17:16 PM, you wrote: PP It just seems to be weird that a subset and its complement PP does not equal the whole table. So the thing is: PP #"!deleted" doesn't include "#NULL" as the set filtered by PP the clause 'WHERE comment!="deleted"' doesn't

buggy support for cp1257

2001-03-08 Thread Rimantas Liubertas
Hello mysql, (Note: this post contains characters in windows-1257 encoding, they may appear incorectly in your e-mail clients). I believed everything is OK with MySQL support for cp1257 charset until I actually tried to sort records alphabeticly. What I find out was: 1. Typo in cp1257.conf

Re: problems with tutorial

2001-03-08 Thread Rimantas Liubertas
Hello David, Thursday, March 08, 2001, 11:44:21 PM, you wrote: DP folks, DP I need help. I installed mysql on NT, everthing seems fine. I wanted to insert fields into a table, as described in the tutorial from a file. It said the default that delimits a field is a tab, DP so I added fields

Re: UNIQUE with NULL columns

2001-03-07 Thread Rimantas Liubertas
Hello john, Thursday, March 08, 2001, 12:19:22 AM, you wrote: jrd with MySQL 3.23.33 on Linux, shouldn't UNIQUE columns that contain NULL jrd values still reject rows that are the same? this isn't working (it allows jrd duplicate rows to be included if one of the columns is NULL). this seems