Cannot transliterate character between character sets
-----------------------------------------------------
Key: CORE-5145
URL: http://tracker.firebirdsql.org/browse/CORE-5145
Project: Firebird Core
Issue Type: Bug
Components: Charsets/Collation
Affects Versions: 2.5.5
Environment: Windows Server 2008 R2 Standard
Reporter: Marcello
Firebird-2.5.5.26952 (x64), IBExpert 2014.7.31.1 with UTF8 in database settings.
1. Create a table
CREATE TABLE PROPS_TXT_2 (
PTX_ID BIGINT NOT NULL,
PTX_ID_OBJ BIGINT NOT NULL,
PTX_ID_LANG BIGINT NOT NULL,
PTX_PROP VARCHAR(48) NOT NULL,
PTX_VALUE_UTF VARCHAR(8191) CHARACTER SET UTF8
);
2. Make an insertion
INSERT INTO PROPS_TXT_2
(PTX_ID, PTX_ID_OBJ, PTX_ID_LANG, PTX_PROP, PTX_VALUE, PTX_VALUE_UTF)
VALUES
(970952385001, 895116244001, 27004, 'EV_NAME', 'Plokstos siules', 'Plokstos
siules');
3. Create and execute a procedure:
CREATE OR ALTER PROCEDURE GET_TOVAR_NAME_NEW_2
returns (
yname varchar(8191) character set utf8)
as
declare variable s varchar(8191) character set utf8;
begin
select pr.ptx_value_utf
from props_txt_2 pr
where pr.ptx_id = 970952385001
into :s;
yname = :s; -- here is an error
suspend;
end
I get an error at marked line: Cannot transliterate character between character
sets
--
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
------------------------------------------------------------------------------
Transform Data into Opportunity.
Accelerate data analysis in your applications with
Intel Data Analytics Acceleration Library.
Click to learn more.
http://pubads.g.doubleclick.net/gampad/clk?id=278785111&iu=/4140
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
