Subject | Alias not working in having / utf8_ci |
---|---|
Author | tjelvare |
Post date | 2007-11-21T23:14:49Z |
Hi all,
Running 2.1 beta 2, win32
§1:
SELECT count("UID") as a2
FROM "Units"
where "PostalCode" is not null
group by "PostalCode"
having count("UID")>3 //not working: having a2>3
order by a2 desc
a2 works fine in order-clause, but not in having.
Bugging, but bug or the fb-way? (having a2 works in mys*l)
§2:
UTF8-CI for localized collations (SV_SV),
found http://tracker.firebirdsql.org/browse/CORE-972,
any more info regarding this?
Tried setting unicode_ci on a utf8-database, works
almost, but not the SV_SV-way, Ö should be after Z,
positioned at O.
I've read the /doc/whatsnew2.1 about create collation but
couldn't really get it.
According to fbintl.conf iso8859_1 is the only way
to go for SV_SV, need win1252 or utf8, should I put
win1252-data into a iso8859-field, or any problem with that?
Thankful for best practice.
All the best,
/tj
Running 2.1 beta 2, win32
§1:
SELECT count("UID") as a2
FROM "Units"
where "PostalCode" is not null
group by "PostalCode"
having count("UID")>3 //not working: having a2>3
order by a2 desc
a2 works fine in order-clause, but not in having.
Bugging, but bug or the fb-way? (having a2 works in mys*l)
§2:
UTF8-CI for localized collations (SV_SV),
found http://tracker.firebirdsql.org/browse/CORE-972,
any more info regarding this?
Tried setting unicode_ci on a utf8-database, works
almost, but not the SV_SV-way, Ö should be after Z,
positioned at O.
I've read the /doc/whatsnew2.1 about create collation but
couldn't really get it.
According to fbintl.conf iso8859_1 is the only way
to go for SV_SV, need win1252 or utf8, should I put
win1252-data into a iso8859-field, or any problem with that?
Thankful for best practice.
All the best,
/tj