[Firebird-devel] [ firebird-Field-test-1255347 ] Character transliterate error .

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

Field-test item #1255347, was opened at 2005-08-10 02:50
Message generated for change (Settings changed) made by dimitr
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=593943&aid=1255347&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: Minoru Yoshida (timeful)
>Assigned to: Adriano dos Santos Fernandes (asfernandes)
Summary: Character transliterate error .

Initial Comment:
 I tested the transliterate character of some character
sets which japanese will use.  The target character
sets are SJIS_0208, UTF8, UNICODE_FSS, and EUCJ_0208 by
SJIS_0208 connection. 

 I found the unmatch case in comparison with V1.5.2.
The following EUCJ_0208 characters between SJIS_0208
character sets.

- Single-byte:
 0xA1-DF(63 chars)
- Multi-byte:
 0x8140-EFFC,0x989F-EFFC,0xFA40-FC4B(2,343 chars -JIS
X0208 Not assign chars) 

The unmatch case error is:
arithmetic exception, numeric overflow, or string
truncation
Cannot transliterate character between character sets
----------
FB: V2.0.0.11252(Alpha 3) win32 Superserver.
OS:WindowsXP SP1.
Middleware:IBObjects 4.5B.

----------
The following is the contents of a testing. 

1. Create testing table(e.g. UTF8) :

- CREATE TABLE "TestTable" (
	,"Keycode" VARCHAR(4) NOT NULL
	,"Teststr" VARCHAR(1) CHARACTER SET UTF8
	, CONSTRAINT "PK" PRIMARY KEY  ("Keycode"));

2.Insert testing SQL:

- INSERT INTO TestTable ( Keycode, Teststr ) VALUES(
'Key code' ,'Original char');
- The test character number of cases is 11,443.

e.g. Case Sjis Character 'A' :
Key code is '0041',Original char is 'A'. 

3. Compare testing SQL:

- SELECT Teststr FROM TestTable WHERE Keycode = 'Key
code' ;
- Comparison of the value of Teststr and Original char .

----------
Result document:
http://www.timeful.co.jp/fbmap/FB0003E.htm

All test documents:(sorry, japanese only)
http://www.timeful.co.jp/fbmap/index.htm


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

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