[Firebird-devel] [ firebird-Bugs-1031142 ] PXW_CYRL error

[SourceForge.net <no...@so...>]

Bugs item #1031142, was opened at 2004-09-20 15:00
Message generated for change (Comment added) made by dimitr
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=109028&aid=1031142&group_id=9028

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: Charsets/Collations 
Group: None
Status: Open
Resolution: None
Priority: 5
Submitted By: Andrey Lapin (andreylapin)
Assigned to: Nobody/Anonymous (nobody)
Summary: PXW_CYRL error

Initial Comment:
I have field fs_short_name in table T_ACC_AREAS
with collation PXW_CYRL.

If I use query

select  * from  T_ACC_AREAS c
where
  c.fs_short_name >= 'баланс'
  and
  c.fs_short_name <= '&#1041;&#1040;&#1051;&#1040;&#1053;&#1057;'

server return one row.

If I use query 

select
  *
from
  T_ACC_AREAS c
where
  c.fs_short_name >= '&#1041;&#1040;&#1051;&#1040;&#1053;&#1057;'
  and
  c.fs_short_name <= '&#1041;&#1040;&#1051;&#1040;&#1053;&#1057;'

or query

select
  *
from
  T_ACC_AREAS c
where
  c.fs_short_name >= '&#1041;&#1040;&#1083;&#1072;&#1085;&#1089;'
  and
  c.fs_short_name <= '&#1041;&#1040;&#1051;&#1040;&#1053;&#1057;'

they does not return any rows, but it must.

Note, that 

select
  *
from
  T_ACC_AREAS c
where
  c.fs_short_name >= '&#1041;&#1040;&#1083;&#1072;&#1085;'
  and
  c.fs_short_name <= '&#1041;&#1040;&#1051;&#1040;&#1053;&#1057;'

return valid row.


----------------------------------------------------------------------

>Comment By: Dmitry Yemanov (dimitr)
Date: 2005-05-22 11:50

Message:
Logged In: YES 
user_id=61270

Could you please provide a reproducable test case? Attach
the test database to this message or contact me privately.

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=109028&aid=1031142&group_id=9028