replace funcion with utf-8 extrange behaviour ---------------------------------------------
Key: CORE-4599 URL: http://tracker.firebirdsql.org/browse/CORE-4599 Project: Firebird Core Issue Type: Bug Components: Charsets/Collation Affects Versions: 2.5.3 Environment: windows7 and linux centos 6.5. Database creation script is: create database "localhost:alias" user "username" password "*****" page_size 16384 default character set utf8 collation unicode_ci_ai; Reporter: Pablo León Test done with flamerobin, though also fails from jaybird: recreate table test1 (field1 varchar(50)); insert into test1 values ('PABLO NUÑEZ SANCHEZ'); update test1 set field1=replace(field1,'Ñ','N'); select * from test1; and you obtain "PABLO NÑN SANCNZ" instead of expected "PABLO NUNEZ SANCHEZ". I other situations we obtain an OOM error from firebird or even get a server crash, here is server log: PALEVI-XPS (Server) Fri Nov 07 13:10:53 2014 Access violation. The code attempted to access a virtual address without privilege to do so. This exception will cause the Firebird server to terminate abnormally. PALEVI-XPS (Server) Fri Nov 07 13:10:53 2014 Shutting down the server with 1 active connection(s) to 1 database(s), 0 active service(s) PALEVI-XPS (Server) Fri Nov 07 13:10:58 2014 Firebird shutdown is still in progress after the specified timeout PALEVI-XPS (Server) Fri Nov 07 13:10:58 2014 Operating system call ReleaseSemaphore failed. Error code 6 PALEVI-XPS (Server) Fri Nov 07 13:10:58 2014 Operating system call ReleaseSemaphore failed. Error code 6 PALEVI-XPS (Client) Fri Nov 07 13:10:58 2014 "C:\Program Files\Firebird\Firebird_2_5\bin\fbserver.exe": terminated abnormally (4294967295) -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira ------------------------------------------------------------------------------ Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel