Viewing 15 posts - 136 through 150 (of 234 total)
Most difficult thing with this question was thinking where the trick is hidden.
I understand author has a block to write null=null
🙂
June 2, 2010 at 6:16 am
gserdijn (5/27/2010)
Zero rows. Click. Zero points.
Next time I will wait for the caffeine to do its work....
May 27, 2010 at 1:01 am
Great question.
The first part with deffered table name was easy. I missed the second part - the table is not dropped due to transaction.
May 27, 2010 at 12:04 am
Paul White NZ (5/26/2010)
There's a great set of visual tables showing...
May 26, 2010 at 12:27 pm
Tom Garth (5/26/2010)
while ASCII(@a1) <= ASCII('Z') begin, etc.This...
May 26, 2010 at 12:25 pm
Michael Poppers (5/25/2010)
honza.mf (5/25/2010)
If someone uses case sensitive collation, he will have all characters in uppercase.
Sounds reasonable, but use COLLATE Czech_CS_AS (instead of the case-insensitive collation) -- SELECT DISTINCT will...
May 26, 2010 at 12:03 am
jlennartz (5/25/2010)
If all characters were inserted into DB as upper case how come query is returning lower case?
It's another aspect of this question not mentioned yet: All characters inserted into...
May 25, 2010 at 2:23 pm
Vladan (5/25/2010)
So-called "letter" ch can create some confusion because...
May 25, 2010 at 9:03 am
Michael Poppers (5/25/2010)
malleswarareddy_m (5/25/2010)
...select string from #t where string COLLATE CZECH_CI_AS like '_'
the above you have given returns gives
CH
Ch
ch
¢h
four rows.
...
I was wondering why my SQL Query Analyzer output apparently...
May 25, 2010 at 8:48 am
2 crussell-931424:
Fine, CZECH is funny for you. OK.
Do you think it about other languages? About those with same behaviour? Eg. Traditional_Spanish - AFAIK Spanish is native language in a great...
May 25, 2010 at 7:45 am
skcadavre (5/25/2010)
If "error" had been an option, I'd have...
May 25, 2010 at 4:10 am
ZeroFusion (5/25/2010)
Actually, I'm Czech 🙂 But I suppose the link was meant for other readers. A quick side note: that page looks awesome!
Yes, it was clear to me, you are...
May 25, 2010 at 3:22 am
Hugo Kornelis (5/25/2010)
(note to self: in future, check question category before answering!)
It's a good practice. It made me several times to answer correctly 😉
May 25, 2010 at 2:18 am
vk-kirov (5/25/2010)
honza.mf (5/25/2010)
If someone discover another collation in another language with similar behaviour, I will be very glad to have such information.
Here is a script which finds that collations (you...
May 25, 2010 at 2:16 am
ZeroFusion (5/25/2010)
A note for people not familiar with Czech language: in the Czech alphabet, a letter "CH" is just between letters "H" and "I".
If you want to know more about...
May 25, 2010 at 2:14 am
Viewing 15 posts - 136 through 150 (of 234 total)