|Subject||Re: [firebird-support] After inserting 4683 rows infamous "Cannot transliterate ..." error always|
> I have read several articles about Firebird and charsets and followedDo you mean you are running sql script ?
> the guidelines "Everything You Need to Know About InterBase Character
> but so far I have even no clue what's going on.
> I'm able to insert exactly 4683 rows via a stored procedure from a
> file and then I always get this error message: Cannot transliterate
> character between character sets.
Have you tried it with standard isql ?
Does it contain SET NAMES statement ?
> With IB Expert I can open the table and there is nothing special to see.??? What does it mean "It fails at the line WHERE" ? Do you use some emulator ?
> The stored procedure looks like this:
> CREATE PROCEDURE ADD_POSITION (
> iswhitetomove char(1),
> huffmanfen_input varchar(37))
> returns (
> position_id integer)
> SELECT "Position"."HuffmanFen"
> FROM "Position"
> WHERE "Position"."HuffmanFen" = :huffmanfen_input INTO :position_id;
> if (position_id is null) then begin position_id =
> gen_id("sq_Position",1); INSERT INTO "Position" (OID,
> "Position"."IsWhiteToMove") VALUES (:position_id, :huffmanfen_input,
> :iswhitetomove); end suspend; end^
> It fails at the line "WHERE" where I try to query for :huffmanfen. But
> only after inserting 4683 rows.
> The input parameter of the SP is charset UNICODE_FSS. But this is notThe values do not look like well formed utf8 to me.
> displayed with IB Expert, if the default charset is the same. I also
> tried with default charset none and then explictly set the column of
> the table and the input parameter to UNICODE_FSS, same result. I have
> also tried UT8.
> I'm inserting some unicode stuff for the parameter HuffmanFen like