Update of /cvsroot/monetdb/sql/src/test/BugTracker-2009/Tests
In directory
23jxhf1.ch3.sourceforge.com:/tmp/cvs-serv4744/src/test/BugTracker-2009/Tests
Added Files:
utf8_bug.SF-2822855.sql
Log Message:
propagated changes of Sunday Jul 19 2009 - Monday Jul 20 2009
from the May2009 branch to the development trunk
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2009/07/19 - nielsnes:
src/test/BugTracker-2009/Tests/utf8_bug.SF-2822855.sql,1.1.2.1
applied (adapted) utf8 patch
it fixes utf8 strings lengths, ie we now return number of unicode characters
not number of bytes.
NULL now all have a length of 0 characters
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
--- NEW FILE: utf8_bug.SF-2822855.sql ---
create table utf8len(a varchar(1));
copy 1 records into utf8len from stdin;
0
copy 1 records into utf8len from stdin;
â¬
insert into utf8len values ('â¬');
select a, length(a) AS len from utf8len;
select 'Liever â¬uro' as "Liever euro";
drop table utf8len;
------------------------------------------------------------------------------
Enter the BlackBerry Developer Challenge
This is your chance to win up to $100,000 in prizes! For a limited time,
vendors submitting new applications to BlackBerry App World(TM) will have
the opportunity to enter the BlackBerry Developer Challenge. See full prize
details at: http://p.sf.net/sfu/Challenge
_______________________________________________
Monetdb-sql-checkins mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins
